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

Scott Chapman <scott_list@mischko.com> writes:

> 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?

No, currval() handles that--see the docs.

-Doug