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 <[EMAIL PROTECTED]> 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
pgpfvXJn9NvU2.pgp
Description: PGP signature