I've got a trigger function that gets executed after an insert or an
update. It basically just creates a copy of the row in a history table.
However, there are cases when a row will be updated to be the same as it
was - in other words, no change. In these cases, the history is useless
and taking up space.
So I want the procedure to start with:
IF NEW = OLD then
return NEW;
end if;
thus exiting before the history record gets created.
However, if I do that, I get:
WARNING: line 6 at if
ERROR: NEW used in non-rule query
What is a non-rule query? :(
I'm led to believe by the documentation and other postings I've seen
archived on the web that this should be possible.
Am I doing something wrong, or do I have to do it the long way around
(field by field comparison)?
Thanks,
cf
--
Colin Fox
President
CF Consulting Inc.