Hi.
I need to set a value in a trigger if a column is explicitly NOT specified in
UPDATE's SET-clause.
Like for example having a "BEFORE UPDATE OF NOT"
create TRIGGER my_trigger BEFORE UPDATE OF NOT modified ON my_table FOR EACH
ROW WHEN(OLD.val <> NEW.val) EXECUTE PROCEDURE do_stuff();
I want the trigger to be fired when the column "modified" is NOT specified, is
it possible?
Or - is it possible to check for this in the trigger-function?
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>