Thread: PLSQL Question regarding multiple inserts
Hi all. Quick and perhaps silly question, but... I am using Pg 7.3. I am writing a function using pgplsql. This function will perform multiple inserts. Let's say two of the inserts are as follows: -- id is primary key insert into users (id, username) values (nextval('someSeq'),'somename'); -- id is also a PK insert into log (id, uid, message) values (nextval('someOtherSeq'),XXX,'New Account'); 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. Thanks, HG
Re: PLSQL Question regarding multiple inserts
From
"V i s h a l Kashyap @ [Sai Hertz And Control Systems]"
Date:
Dear Humble Geek , >-- id is primary key >insert into users (id, username) values (nextval('someSeq'),'somename'); >-- id is also a PK >insert into log (id, uid, message) values (nextval('someOtherSeq'),XXX,'New >Account'); >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 > > Nop, If the insert and later on currval('someSeq') is called inside the same function currval will only return the current value that has been effected by the first insert made. -- Best Regards, Vishal Kashyap Director / Lead Developer, Sai Hertz And Control Systems Pvt Ltd, http://saihertz.rediffblogs.com Jabber IM: vishalkashyap@jabber.org ICQ : 264360076 Yahoo IM: mailforvishal@yahoo.com ----------------------------------------------- You yourself, as much as anybody in the entire universe, deserve your love and affection. - Buddha --------------- pgsql=# select marital_status from vishals_life; marital_status ------------------ Single not looking 1 Row(s) affected ___ //\\\ ( 0_0 ) ----------------o0o-----o0o---------------------