Skip site navigation (1) Skip section navigation (2)

Re: PLSQL Question regarding multiple inserts

From: "V i s h a l Kashyap (at) [Sai Hertz And Control Systems]" <sank89(at)sancharnet(dot)in>
To: Humble Geek <humblegeek(at)rogers(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: PLSQL Question regarding multiple inserts
Date: 2004-03-01 04:17:50
Message-ID: 4042B96E.5080808@sancharnet.in (view raw or flat)
Thread:
Lists: pgsql-sql
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(at)jabber(dot)org
ICQ :      264360076
Yahoo  IM: mailforvishal(at)yahoo(dot)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---------------------


In response to

pgsql-sql by date

Next:From: DenisDate: 2004-03-01 05:30:49
Subject: Re: Field list from table
Previous:From: Christopher BrowneDate: 2004-03-01 04:11:31
Subject: Re: User defined types -- Social Security number...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group