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

In response to

• cannot use result of (insert..returning) at 2008-06-04 05:25:11 from dvs

Responses

• Re: cannot use result of (insert..returning) at 2008-06-12 00:50:04 from Bruce Momjian

pgsql-hackers by date

Next:	From: Decibel!	Date: 2008-06-04 12:35:04
	Subject: Re: intercepting WAL writes
Previous:	From: Heikki Linnakangas	Date: 2008-06-04 11:19:42
	Subject: Re: Core team statement on replication in PostgreSQL