On Apr 25, 2005, at 11:00 PM, Tom Lane wrote:
> DO INSTEAD means that the *original* query will not execute; it does
> not suppress actions produced by other rules.
Ah!
> 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?
The documentation says that they evaluate in alphabetical order by
name. So I would expect that the first one to have its WHERE statement
evaluate to true would short-circuit the execution of the remaining
rules.
Regards,
David