On Sat, 29 Jun 2019 at 14:54, Igal @ Lucee.org <i...@lucee.org> wrote: > create trigger tr_on_table_modified after insert or delete or update > on some_table for each row execute procedure on_table_modified();
> I can see in the output the notices with the expected values, but the value > in the updated record is not lower-cased. You'll need a BEFORE trigger, not an AFTER trigger. https://www.postgresql.org/docs/current/sql-createtrigger.html -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
