Instead of this:
create function some_trigger() returns trigger as $$
begin
if TG_OP = 'DELETE' then
insert into audits values (OLD.value);
else
insert into audits values (NEW.value);
end if;
return NULL;
end
$$ language plpgsql;
create trigger some_trigger after insert on products
for each row execute procedure some_trigger();
I wish I could do:
create trigger some_trigger after insert on products
execute procedure do $$ begin
insert into audits values (CHANGED.value);
end $$ language plpgsql;
Changes/improvements:
1. Triggers default to 'for each row'
2. Triggers can use anonymous functions
3. Triggers can access a special CHANGED value that's either NEW for insert or updates, or OLD for deletes.
4. Default for 'after insert' triggers is to return null, as I believe it doesn't matter what you return here.
5. Way less repetitive typing.
Thoughts? Is this a terrible idea?