Skip site navigation (1) Skip section navigation (2)

FW: RETURNING in stored procedure

From: "Mehrotra, Abhinav (GE Healthcare)" <Abhinav(dot)Mehrotra(at)ge(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: FW: RETURNING in stored procedure
Date: 2009-05-22 10:36:17
Message-ID: 516FCC77ADD26141AF6F0EA95E0AA564570A58@BANMLVEM04.e2k.ad.ge.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Alan McKayDate: 2009-05-22 23:33:46
Subject: thanks for an absolutely fantastic #pgcon!
Previous:From: Leif B. KristensenDate: 2009-05-22 09:16:22
Subject: Re: RETURNING in stored procedure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group