Re: FW: RETURNING in stored procedure

On Saturday 23. May 2009, Jasen Betts wrote:
>On 2009-05-22, Mehrotra, Abhinav (GE Healthcare)
<Abhinav(dot)Mehrotra(at)ge(dot)com> 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.

I still think that OP's syntax is the most intuitive one, and IMO it
should be possible to do variable assignments this way in plpgsql from
RETURNING values. It's the «normal» way of doing assignments in almost
every other computer language that I know of.
--
Leif Biberg Kristensen | Registered Linux User #338009
Me And My Database: http://solumslekt.org/blog/