Indicates if the trigger fired for an UPDATE operation

Available inPSQL — triggers only

TypeBOOLEAN

Syntax

UPDATING

Intended for use in multi-action triggers.

Example

if (inserting or updating) then
begin
  if (new.serial_num is null) then
    new.serial_num = gen_id(gen_serials, 1);
end