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

From Bruce Momjian
Subject Re: cannot use result of (insert..returning)
Date
Msg-id 200806120050.m5C0o4O22459@momjian.us
Whole thread Raw
In response to Re: cannot use result of (insert..returning)  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Responses Re: cannot use result of (insert..returning)  (Andrew Dunstan <andrew@dunslane.net>)
List pgsql-hackers
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. +


pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Overhauling GUCS
Next
From: Bruce Momjian
Date:
Subject: Re: Overhauling GUCS