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

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.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com