9.8DELETING

Available inPSQL

Typeboolean

DescriptionAvailable in triggers only, DELETING indicates if the trigger fired because of a DELETE operation. Intended for use in multi-action triggers.

Example

  |if (deleting) then
  |begin
  |  insert into Removed_Cars (id, make, model, removed)
  |    values (old.id, old.make, old.model, current_timestamp);
  |end