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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: How to specify that a trigger should fire when column is NOT in SET-clause?
Дата
Msg-id CAKFQuwbrC7nDDJ3DQPNH9aBZCbmJADy4pTH+S2h5co6kO+pzSw@mail.gmail.com
обсуждение исходный текст
Ответ на How to specify that a trigger should fire when column is NOT in SET-clause?  (Andreas Joseph Krogh <andreas@visena.com>)
Список pgsql-general
Дерево обсуждения

On Friday, December 25, 2020, Andreas Joseph Krogh <andreas@visena.com> wrote:
Hi.
 
I need to set a value in a trigger if a column is explicitly NOT specified in UPDATE's SET-clause.
 

Beat you can probably do is rely on the fact that if its not specified it doesn’t change and do nothing within the trigger in that case.

David J. 

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

Предыдущее
От: Andreas Joseph Krogh
Дата:
Сообщение: How to specify that a trigger should fire when column is NOT in SET-clause?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: How to specify that a trigger should fire when column is NOT in SET-clause?