Trigger with conditional predicates

Hi all and a happy new Year!

We have an Oracle schema that is to be converted to PostgreSQL, where conditional predicates are used in some
triggers.

In particular, columns are populated with values if they are not specified in the update statement which is used.
Usually with an expression like this:

      IF NOT UPDATING('IS_CANCELED')
      THEN
         :new.is_canceled := ...;
      END IF;

I have not found anything similar in PostgreSQL. What is the common approach to this problem?

BR
Dirk


--
Dirk Mika
Software Developer

mika:timing GmbH
Strundepark - Kürtener Str. 11b
51465 Bergisch Gladbach
Germany

fon +49 2202 2401-1197
dirk.mika@mikatiming.de
www.mikatiming.de

AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884
Geschäftsführer: Harald Mika, Jörg Mika



## 2020 - Das Jahr der Veränderungen
## https://now.mikatiming.de/story/2020-das-jahr-der-veraenderungen/