Horton

Re: SQL-question: returning the id of an insert querry

Scott Chapman <scott_list@mischko.com>

View thread View on postgr.es
From: Scott Chapman <scott_list@mischko.com>
To: Martijn van Oosterhout <kleptog@svana.org>, Andreas Fromm <Andreas.Fromm@physik.uni-erlangen.de>
Cc: pgsql-general@postgresql.org
Date: 2003-11-09T18:26:51Z
Lists: pgsql-general 
On Sunday 09 November 2003 03:13, Martijn van Oosterhout wrote:
> After you've done the insert on the address table, you can use
> currval('address_id_seq') (or equivalent) to get the ID. Ofcourse you
> have to have used nextval() for the original insert.

What if someone else inserts another address before I get the currval?  
I'm out of luck then, right?