On Nov 8, 2007 11:56 AM, Oliveiros Cristina <[EMAIL PROTECTED]> wrote: > > Hello, All, > > I have the need to know the primary key assigned to a record I've just > INSERTed . > > Is there an easy way to solve this ? > > Similar to SQLServer's SELECT scope_identity() ; ?
In 8.2 and up:
insert into table a (info) values ('abc') returning id;
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
