Re: DO INSTEAD and conditional rules

Neil Conway <neilc@samurai.com> writes:
> Note that although both rules are DO INSTEAD, they both get fired for 
> the insertion.

DO INSTEAD means that the *original* query will not execute; it does
not suppress actions produced by other rules.  If we did not define
it that way, I think your example would have to error out --- how
would you choose which INSTEAD rule wins?
        regards, tom lane