[BUGS] rule system re-evaluates expressions

2005-01-03 Thread jan pfaler
The rule-system seems to evaluate a functional value of a column anew. Please confim if this is a documented/intentional behaviour of the rule system? The order of evaluation of the expresion(s) within original statemant and rule differ between "on insert" and "on update" rules. For details see

Re: [BUGS] rule-system revaluates the functionale expressions

2005-01-03 Thread jan pfaler
Thanks Tom, Refering to your answer: The syntax "NEW.column" seems to hint rather to "the new value" of column as opposed to "the expression for the new value", c.f. "OLD.column". The fact that the order of evaluation changes underlines the inconsistency; the order of evaluation would not matter