12.10. INSERTING

Indicates if the trigger fired for an INSERT operation

Available inPSQL — triggers only

TypeBOOLEAN

Syntax 

  |INSERTING

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