Re: cannot use result of (insert..returning) - Mailing list pgsql-hackers

Bruce Momjian wrote:
> Heikki Linnakangas wrote:
>   
>> dvs wrote:
>>     
>>> Hello,
>>>
>>> I need to use query like:
>>>    select (insert into test (a) values (x) returning b),c from anytable 
>>> where condition
>>> but it say
>>>    ERROR: syntax error at or near "into"
>>>
>>> Is this a bug?
>>>       
>> No, it's a known limitation.
>>     
>
> Is there a TODO item for this?  I don't see one, do you?
>
>   
Allow INSERT/UPDATE ... RETURNING inside a SELECT 'FROM' clause

http://archives.postgresql.org/pgsql-general/2006-09/msg00803.php
http://archives.postgresql.org/pgsql-hackers/2006-10/msg00693.php

?

cheers

andrew