Re: FW: RETURNING in stored procedure

On 2009-05-22, Mehrotra, Abhinav (GE Healthcare) <Abhinav(dot)Mehrotra(at)ge(dot)com> wrote:
>
> 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;

postgres seems to translate anything after a := into a select,
(something I often exploit)

thus you can do

var := expression FROM table_name WHERE condition_expression ;

etc.

but INSERT-RETURNING isn't treated like an expression, or like a
query so it doesn't work as above.

> INSERT INTO temp("hello") RETURNING seq INTO val;

yeah.