Search Postgresql Archives

Re: SEQUENCE primary key

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Chris <dmagick@xxxxxxxxx>
Subject: Re: SEQUENCE primary key
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Tue, 13 Feb 2007 21:20:48 -0500
Cc: John McCawley <nospam@xxxxxxxxxxxx>, gustavo halperin <ggh.develop@xxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxx
Comments: In-reply-to Chris <dmagick@xxxxxxxxx> message dated "Wed, 14 Feb 2007 13:06:46 +1100"
In-reply-to: <45D26EB6.9090500@xxxxxxxxx>
References: <45D216E5.1020007@xxxxxxxxx> <45D26146.80903@xxxxxxxxxxxx> <45D26EB6.9090500@xxxxxxxxx>

Chris <dmagick@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- SEQUENCE primary key
  - From: gustavo halperin
- Re: SEQUENCE primary key
  - From: John McCawley
- Re: SEQUENCE primary key
  - From: Chris

Prev by Date: suggestions on improving a query
Next by Date: Re: suggestions on improving a query
Previous by thread: Re: SEQUENCE primary key
Next by thread: suggestions on improving a query
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux