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: (view raw, whole thread or download thread mbox)
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.
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

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


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-2017 The PostgreSQL Global Development Group