Re: insert/update/delete returning and rules

--On Dienstag, August 15, 2006 16:33:27 -0400 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
wrote:
> I'm tempted to suggest that the RETURNING commands might need to be
> separate rule events, and that to support this you'd need to write
> an additional rule:
>
> CREATE RULE r1 AS ON INSERT RETURNING TO myview DO INSTEAD
> INSERT ... RETURNING ...
> ...
>
> But even this seems like it would fail in complicated cases. What if
> the view is a join, and your ON INSERT rule inserts into two different
> underlying tables in two commands? If you need fields from both tables
> to generate a full RETURNING list then there's no apparent way to make
> it work.
>
> Ugh. Any ideas out there?
CREATE RULE r1 AS ON INSERT RETURNING TO myview DO INSTEAD
INSERT ... INTO tbl_1;
INSERT ... INTO tbl_2;
RETURNING SELECT .... FROM tbl_1, tbl_2 WHERE ...;

Just what crossed my mind first, no idea whether this is implementable or
realistic or whatever.

Mit freundlichem Gruß
Jens Schicke
--
Jens Schicke j(dot)schicke(at)asco(dot)de
asco GmbH http://www.asco.de
Mittelweg 7 Tel 0531/3906-127
38106 Braunschweig Fax 0531/3906-400