FW: RETURNING in stored procedure

Thanks, this works :)

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Leif B.
Kristensen
Sent: Friday, May 22, 2009 2:46 PM
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] RETURNING in stored procedure

On Friday 22. May 2009, Mehrotra, Abhinav (GE Healthcare) wrote:
>Val:= insert into temp("hello") RETURNING seq;

You may try:

INSERT INTO temp("hello") RETURNING seq INTO val;
--
Leif Biberg Kristensen | Registered Linux User #338009 Me And My
Database: http://solumslekt.org/blog/

--
Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice