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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
