Re: INSERT INTO on AFTER UPDATE trigger

[Peter Brawley]

> I want to insert a record into the row_change table
> for each field that changed in the trigger field:

You mean the requirement is to insert a row_change row for every `field` column where the NEW column value differs from the OLD? That'll require a block like ...

if new.col1 <> old col1 then
  insert into row_change ...
end if;

... for each `field` column.