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