> create function au_col()
> returns opaque
> as 'begin
> old.mut_id = current_user;
> old.mut_timestamp = CURRENT_TIMESTAMP;
> return old;
> end;'
> language 'plpgsql';
As a note, while this works in your case, because you're changing
all the columns inside the trigger, in general, you want to be making
modifications to NEW and returning NEW on updates unless you
want to ignore the actual sets done by the update statement (which is
sometimes what you want).
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
