It worked perfectly.
Thanks a million, Scott.
Best,
Oliveiros
----- Original Message -----
From: "Scott Marlowe" <[EMAIL PROTECTED]>
To: "Oliveiros Cristina" <[EMAIL PROTECTED]>
Cc: <pgsql-sql@postgresql.org>
Sent: Thursday, November 08, 2007 6:03 PM
Subject: Re: [SQL] Obtaining the primary key of the record just inserted
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 5: don't forget to increase your free space map settings
