Scott Marlowe <smarlowe@g2switchworks.com> writes:
> Now I'm thinking I should make a patch for a demonstration of making a
> rule with >1 action though...
You're right, there are no such examples. It would be interesting to
make a full-fledged demonstration of maintaining a join view (where
delete from the join means delete from both tables) --- in particular
the need to use an outer join so that the first table delete doesn't
cause rows to disappear from the view.
regards, tom lane