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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Andreas Joseph Krogh <andreas(at)visena(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: How to specify that a trigger should fire when column is NOT in SET-clause?
Date: 2020-12-25 16:04:16
Message-ID: CAKFQuwbrC7nDDJ3DQPNH9aBZCbmJADy4pTH+S2h5co6kO+pzSw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday, December 25, 2020, Andreas Joseph Krogh <andreas(at)visena(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-12-25 16:48:39 Re: How to specify that a trigger should fire when column is NOT in SET-clause?
Previous Message Andreas Joseph Krogh 2020-12-25 13:52:28 How to specify that a trigger should fire when column is NOT in SET-clause?