Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: How to specify that a trigger should fire when column is NOT in SET-clause?
Date
Msg-id CAKFQuwbrC7nDDJ3DQPNH9aBZCbmJADy4pTH+S2h5co6kO+pzSw@mail.gmail.com
Whole thread Raw
In response to How to specify that a trigger should fire when column is NOT in SET-clause?  (Andreas Joseph Krogh <andreas@visena.com>)
List pgsql-general
Tree view

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 by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: How to specify that a trigger should fire when column is NOT in SET-clause?
Next
From: Adrian Klaver
Date:
Subject: Re: How to specify that a trigger should fire when column is NOT in SET-clause?