Search Postgresql Archives

Re: SEQUENCE primary key

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

To: John McCawley <nospam@xxxxxxxxxxxx>
Subject: Re: SEQUENCE primary key
From: Chris <dmagick@xxxxxxxxx>
Date: Wed, 14 Feb 2007 13:06:46 +1100
Cc: gustavo halperin <ggh.develop@xxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <45D26146.80903@xxxxxxxxxxxx>
References: <45D216E5.1020007@xxxxxxxxx> <45D26146.80903@xxxxxxxxxxxx>
User-agent: Thunderbird 1.5.0.9 (Windows/20061207)

John McCawley wrote:

In PostgreSQL 8 and up:

SELECT lastval();


Actually it's better to use currval.

Seehttp://people.planetpostgresql.org/xzilla/index.php?/archives/169-Is-lastval-evil.html


--
Postgresql & php tutorials
http://www.designmagick.com/

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

Follow-Ups:
- Re: SEQUENCE primary key
  - From: Tom Lane

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

Prev by Date: Re: SEQUENCE primary key
Next by Date: suggestions on improving a query
Previous by thread: Re: SEQUENCE primary key
Next by thread: Re: SEQUENCE primary key
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