Postgres Pro
Downloads
Home   >   mailing lists

Re: SEQUENCE primary key - Mailing list pgsql-general

From Tom Lane
Subject Re: SEQUENCE primary key
Date
Msg-id 5868.1171419648@sss.pgh.pa.us
Whole thread Raw
In response to Re: SEQUENCE primary key  (Chris <dmagick@gmail.com>)
List pgsql-general
Tree view 
Chris <dmagick@gmail.com> writes:
> Actually it's better to use currval.

Right.  Also, in 8.2 and up there's INSERT RETURNING, which is far
more flexible --- for instance it could pull back an insertion
timestamp.

            regards, tom lane

pgsql-general by date:

Previous
From: Rajarshi Guha
Date:
Subject: suggestions on improving a query
Next
From: "Adam Rich"
Date:
Subject: Re: suggestions on improving a query