Re: [INTERFACES] [pgaccess-users] RE: bugzilla.pgaccess.org

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