Thread: returning the primary key value

returning the primary key value

From
"Jason Tesser"
Date:
I have a stored proc in which I want to retur the primary key of an insert statement that the stored proc just ran.
Howcan  I do that?   

Re: returning the primary key value

From
Michael Fuhr
Date:
On Wed, Sep 21, 2005 at 02:22:22PM -0500, Jason Tesser wrote:
> I have a stored proc in which I want to retur the primary key of
> an insert statement that the stored proc just ran.  How can  I do
> that?

If the primary key is a SERIAL column then see "How do I get the
value of a SERIAL insert?" in the FAQ:

http://www.postgresql.org/docs/faqs.FAQ.html#4.11.2

--
Michael Fuhr

Re: returning the primary key value

From
vishal saberwal
Date:
hi,

If this primary key is a guid or a number that you create as unique, create it local to your function and then return the same after inserting within the function.

create or replace function test_insert() returns guid as $$
DECLARE
 ret guid;
BEGIN
   select into ret newid();
   -- ret is the primary key for the table "Table_a"
   insert into table_a (ret, "Value1","Value2");
  if not found then
     ..............
  end if;
  return ret;
END;
$$ language plpgsql;

your question is too abstract, i tink we will nee more information to solve your problem

vish

On 9/21/05, Michael Fuhr <mike@fuhr.org> wrote:
On Wed, Sep 21, 2005 at 02:22:22PM -0500, Jason Tesser wrote:
> I have a stored proc in which I want to retur the primary key of
> an insert statement that the stored proc just ran.  How can  I do
> that?

If the primary key is a SERIAL column then see "How do I get the
value of a SERIAL insert?" in the FAQ:

http://www.postgresql.org/docs/faqs.FAQ.html#4.11.2

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend