Oliver Elphick <olly(at)lfix(dot)co(dot)uk> writes:
> On Sat, 2004-07-31 at 23:57, Marc Boucher wrote:
>> Now my questions are:
>> - Is this an expected behavior ?
> I couldn't answer that.
It is. Rules are essentially macros and so you have all the usual
potential gotchas with multiple evaluations of their input arguments.
The recommended way to handle this type of problem is with a trigger
rather than a rule.
regards, tom lane