RETURNING in stored procedure - Mailing list pgsql-novice

From Mehrotra, Abhinav (GE Healthcare)
Subject RETURNING in stored procedure
Date
Msg-id 516FCC77ADD26141AF6F0EA95E0AA5645708EB@BANMLVEM04.e2k.ad.ge.com
Whole thread Raw
Responses Re: RETURNING in stored procedure
List pgsql-novice
Hi,

I have a table
 temp (name varchar(64),  seq  bigserial)

And a stored procedure :

Create function ......
..........
Val bigint;
BEGIN:
Val:= insert into temp("hello") RETURNING seq;
END;


I am unable to assign the value returned by seq into val.




-Abhinav

pgsql-novice by date:

Previous
From: Jana
Date:
Subject: Re: Custom sorting
Next
From: "Leif B. Kristensen"
Date:
Subject: Re: RETURNING in stored procedure