On 2009-05-23, Leif B. Kristensen <leif(at)solumslekt(dot)org> wrote:
> On Saturday 23. May 2009, Jasen Betts wrote:
>>On 2009-05-22, Mehrotra, Abhinav (GE Healthcare)
>>>>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 ;
>>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;
> 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.
I agree, however Insert...returning can't be used as a subquery.
which is effectively what he was doing.
I'm not sure why it can't be used as a subquery.
In response to
pgsql-novice by date
|Next:||From: Luiz Eduardo Cantanhede Neri||Date: 2009-05-24 17:54:47|
|Subject: INHERIT and FOREIGN KEY issues|
|Previous:||From: Just E. Mail||Date: 2009-05-23 21:05:39|
|Subject: Create Database/Tables -PostgreSQL|