Re: How I can read-back a serial value just inserted? - Mailing list pgsql-general

On Thursday 18 January 2007 00:57, Adam Rich wrote:
> If it's a recent PG:
>
> select lastval()
>
> See this:
>
> http://www.postgresql.org/docs/8.2/interactive/functions-sequence.html
>

probably more important that you see this:
http://people.planetpostgresql.org/xzilla/index.php?/archives/169-Is-lastval-evil.html

:-)

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL