Bradley Baetz <bbaetz@student.usyd.edu.au> writes:
> I'm referring to the mysql |timestamp| type, which will update that
> column's contents to |now()| when any UPDATE is given for that partcular
> row, unless the column was assigned to. I don't know how to handle the
> last part in a trigger.
It'd probably be close enough to have an UPDATE trigger that does
if (new.timestamp = old.timestamp) new.timestamp = now();
regards, tom lane