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

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Friday, December 25, 2020, Andreas Joseph Krogh <andreas@xxxxxxxxxx> 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.