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