How to specify that a trigger should fire when column is NOT in SET-clause?

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема How to specify that a trigger should fire when column is NOT in SET-clause?
Дата
Msg-id VisenaEmail.26.7cbf2947c8d23ceb.1769a2755ff@tc7-visena
обсуждение исходный текст
Ответы Re: How to specify that a trigger should fire when column is NOT in SET-clause?
Re: How to specify that a trigger should fire when column is NOT in SET-clause?
Список pgsql-general
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
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Stats for indexes on expressions
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: How to specify that a trigger should fire when column is NOT in SET-clause?