[GENERAL] Can't SELECT from (INSERT ... RETURNING)

2007-07-18 Thread Nico Sabbi
I thought I could use the output of INSERT...RETURNING as a set of tuples for a subquery, but it seems it's not the case: nb1=# select * from (insert into m(a) values(112) returning a); ERROR: syntax error at or near into LINE 1: select * from (insert into m(a) values(112) returni...

Re: [GENERAL] Can't SELECT from (INSERT ... RETURNING)

2007-07-18 Thread Merlin Moncure
On 7/18/07, Nico Sabbi [EMAIL PROTECTED] wrote: I thought I could use the output of INSERT...RETURNING as a set of tuples for a subquery, but it seems it's not the case: nb1=# select * from (insert into m(a) values(112) returning a); ERROR: syntax error at or near into LINE 1: select * from