Re: multiple action rules - Mailing list pgsql-general

From Tom Lane
Subject Re: multiple action rules
Date
Msg-id 4821.1119536692@sss.pgh.pa.us
Whole thread Raw
In response to Re: multiple action rules  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Propogating conditions into a query
Next
From: Roberto Pellagatti
Date:
Subject: plpgsql and schema