Robert Fitzpatrick <lists@webtent.net> 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