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 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://www.visena.com> <https://www.visena.com>
