| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Humble Geek <humblegeek(at)rogers(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PLSQL Question regarding multiple inserts |
| Date: | 2004-02-28 20:40:06 |
| Message-ID: | 20040228204006.GA12519@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Futerko | 2004-02-28 21:12:11 | pgCluster in production environment |
| Previous Message | Karl O. Pinc | 2004-02-28 20:38:08 | Triggers per transaction, workaround? prospects? |