CSN <[EMAIL PROTECTED]> writes: > I'm trying to set up a trigger that simply updates a > field's corresponding timestamp to now() whenever the > field is updated. But it's not working. Trying to > debug, I commented out the inner IF and END and the > log seemed to indicate infinite recursion occurred. My > next guess is that perhaps NULL's in OLD.stuff is > causing the IF to behave other than what I expect.
Make it a BEFORE UPDATE trigger and just set NEW.stuff_ts to now(), rather than doing another query inside the trigger function. -Doug ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
