Thanks, this works :)
-----Original Message-----
From: pgsql-novice-owner@postgresql.org
[mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Leif B.
Kristensen
Sent: Friday, May 22, 2009 2:46 PM
To: pgsql-novice@postgresql.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@postgresql.org) To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice