<< SQLSTATE | FB 2.5 Language Reference | NULL literals allowed as operands >>
<< SQLCODE | FB 2.1 Language Reference | Operators and predicates >>
<< SQLCODE | FB 2.0 Language Reference | Operators and predicates >>

UPDATING

Available in: PSQL

Added in: 1.5

Description

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

Type: Boolean

Example

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

back to top of page
<< SQLSTATE | FB 2.5 Language Reference | NULL literals allowed as operands >>
<< SQLCODE | FB 2.1 Language Reference | Operators and predicates >>
<< SQLCODE | FB 2.0 Language Reference | Operators and predicates >>