ON UPDATE trigger question
От
Josh Trutwin
Тема
ON UPDATE trigger question
Дата
Msg-id
20070912135613.167c55a4@sinkhole.intrcomm.net
Список
Дерево обсуждения
ON UPDATE trigger question Josh Trutwin <josh@trutwins.homeip.net>
Re: ON UPDATE trigger question Jorge Godoy <jgodoy@gmail.com>
Re: ON UPDATE trigger question hubert depesz lubaczewski <depesz@depesz.com>
If I create an ON UPDATE trigger run on each row after update, does
the trigger fire only on rows affected by the update or for all rows?
For example:
CREATE TRIGGER my_update_trigger
AFTER UPDATE ON my_table
FOR EACH ROW
EXECUTE PROCEDURE my_update_proc;
UPDATE my_table SET my_val = my_val * 2;
Will the trigger fire on rows that have NULL for my_val?
If so, would this be ok in the trigger proc to generically tell if
the row actually changed:
-- check if update affected the row
IF TG_OP = 'UPDATE' THEN
IF OLD = NEW THEN
RETURN NULL;
END IF;
END IF;
-- further processing here
Or would you have to compare each field in OLD, NEW to see if
anything actually changed?
Josh
В списке pgsql-general по дате отправления