Re: Return of INSTEAD rules

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > I am confused how yours differs from mine.  I don't see how the last
> > matching tagged query would not be from an INSTEAD rule.
> 
> You could have both INSTEAD and non-INSTEAD rules firing for the same
> original query.  If the alphabetically-last rule is a non-INSTEAD rule,
> then there's a difference.

How do we get multiple rules on a query?  I thought it was mostly
INSERT/UPDATE/DELETE, and those all operate on a single table.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073