A table has TRIGGER BEFORE UPDATE, TRIGGER AFTER UPDATE and RULE ON UPDATE.
1. What is the order these three are executed?
2. Are the actions of one of them visible to the following ones, or they all
refer strictly to the record before update? E.g.: If the TRIGGER BEFORE
UPDATE changes a value in the new record, is this visible to the RULE and to
the TRIGGER AFTER UPDATE?
Thank you all.