11.10 INSERTING

Available inPSQL

TypeBOOLEAN

Syntax

1. INSERTING

Available in triggers only, INSERTING indicates if the trigger fired because of an INSERT operation. Intended for use in multi-action triggers.

Example

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