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

>> I need to use query like:
>>    ,c from anytable where condition
>> but it say
>>    ERROR: syntax error at or near "into"
>
> did you try with:
> select (insert into test (a) values (x) returning b) query_a JOIN c ON ...
> ?

you about
   select * from (insert into test (a) values (x) returning b) z
?
it get the same error...