[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Billable
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] Billable |
Date: |
Sat, 4 May 2013 17:03:34 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
On Sat, May 04, 2013 at 02:42:45PM +0000, Jim Busser wrote:
> Can the following please be further described, as to what it does? Has it
> previously been used and is it anywhere else already documented?
>
> set standard_conforming_strings to on;
http://www.postgresql.org/docs/9.2/static/runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION
In this case it is used to make PostgreSQL accept the
U&'\20A8'
http://www.postgresql.org/docs/9.2/static/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS-UESCAPE
used to insert the Rupee currency symbol.
> Secondly, I was going to ask about
>
> currval('ref.data_source_pk_seq')
http://www.postgresql.org/docs/9.2/static/functions-sequence.html
> wherein a field was being referenced by concatenating _ (as above) and adding
> _seq
Default sequence names
http://www.postgresql.org/docs/9.2/static/sql-createsequence.html
as created by PostgreSQL conform to
schema.TableName_ColumnName_seq
The actual name can be found by looking at
\d schema.table-name
within the database.
Karsten
> however as seemingly described here
>
>
> http://dba.stackexchange.com/questions/3281/how-do-i-use-currval-in-postgresql-to-get-the-last-inserted-id
>
> it's how to reference currval:
>
> tablename_columnname_seq
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
- Re: [Gnumed-devel] Billable, Vaibhav Banait, 2013/05/03
- Re: [Gnumed-devel] Billable, Vaibhav Banait, 2013/05/04
- Re: [Gnumed-devel] Billable, Vaibhav Banait, 2013/05/05
- Re: [Gnumed-devel] BILLABLE, Vaibhav Banait, 2013/05/09
- Re: [Gnumed-devel] BILLABLE, Vaibhav Banait, 2013/05/09
- Re: [Gnumed-devel] BILLABLE, Vaibhav Banait, 2013/05/11