Re: PLSQL Question regarding multiple inserts - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: PLSQL Question regarding multiple inserts
Date
Msg-id 20040228204006.GA12519@svana.org
Whole thread Raw
In response to PLSQL Question regarding multiple inserts  ("Humble Geek" <humblegeek@rogers.com>)
List pgsql-general
On Wed, Feb 25, 2004 at 04:11:37AM +0000, Humble Geek wrote:
> Assume XXX is the id from the first insert. How do I get that number? Not
> currval('someSeq') -  'cause someone else may have performed an insert - but
> the id for that specific insert.

Read the documentation carefully, currval() does what you want, it
isn't affected by concurrent inserts.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> If the Catholic church can survive the printing press, science fiction
> will certainly weather the advent of bookwarez.
>    http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow

Attachment

pgsql-general by date:

Previous
From: Mike Futerko
Date:
Subject: pgCluster in production environment
Next
From: Chris Browne
Date:
Subject: Re: efficient storing of urls