gnumed-devel
[Top][All Lists]
Advanced

[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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]