Robert Fitzpatrick <lists@xxxxxxxxxxx> writes: > Is it not possible to set the value of a field by reference of NEW.field > in an AFTER trigger? An AFTER trigger can't retroactively affect the update that already happened, if that's what you're imagining this would do. Use a BEFORE trigger if you want to affect what gets stored. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general