Re: [HACKERS] cannot use result of (insert..returning)

[Heikki Linnakangas]

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

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers