11.8 DELETING

Available inPSQL

TypeBOOLEAN

Syntax

1. DELETING

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

Example

1. if (deleting) then
2. begin
3. insert into Removed_Cars (id, make, model, removed)
4. values (old.id, old.make, old.model, current_timestamp);
5. end