Re: [GENERAL] INSERT RETURNING rule for joined view

2009-06-01 Thread Merlin Moncure
On Mon, Jun 1, 2009 at 2:35 PM, Tom Lane wrote: > Sava Chankov writes: >> Is there a way to make RETURNING return all view columns? > > Something like > > CREATE RULE _insert AS ON INSERT TO j DO INSTEAD( >  INSERT INTO a (id,name) VALUES (NEW.id, NEW.name); >  INSERT INTO b (id,surname) VALUES (

Re: [GENERAL] INSERT RETURNING rule for joined view

2009-06-01 Thread Tom Lane
Sava Chankov writes: > Is there a way to make RETURNING return all view columns? Something like CREATE RULE _insert AS ON INSERT TO j DO INSTEAD( INSERT INTO a (id,name) VALUES (NEW.id, NEW.name); INSERT INTO b (id,surname) VALUES (NEW.id,NEW.surname) RETURNING id, (SELECT name FROM a WH