Postgres Pro
Downloads
Home   >   mailing lists

Re: RETURNING in stored procedure - Mailing list pgsql-novice

From Leif B. Kristensen
Subject Re: RETURNING in stored procedure
Date
Msg-id 200905221116.22549.leif@solumslekt.org
Whole thread Raw
In response to RETURNING in stored procedure  ("Mehrotra, Abhinav (GE Healthcare)" <Abhinav.Mehrotra@ge.com>)
List pgsql-novice
Tree view 
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/

pgsql-novice by date:

Previous
From: "Mehrotra, Abhinav (GE Healthcare)"
Date:
Subject: RETURNING in stored procedure
Next
From: "Mehrotra, Abhinav (GE Healthcare)"
Date:
Subject: FW: RETURNING in stored procedure