Bradley Baetz <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
