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 (
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