Hi,
I've defined a small trigger to increment a field each time the row is updated:
> CREATE TRIGGER inc_trigger BEFORE UPDATE ON Table FOR EACH ROW EXECUTE PROCEDURE inc_function();
Works quite well, however the trigger is also fired if the table
itself is modified.
When deleting or inserting a single row, the trigger is executed for
all rows contained in the table.
Is this intetional, and if so, how can I get the behaviour to only
execute the trigger when an update on the relation is performed?
Thank you in advance, Clemens