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

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?

--
Bruce Momjian <bruce@momjian.us>

http://momjian.us

EnterpriseDB

http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

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