Scott Chapman <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
