11.15OLD

Available inPSQL, triggers only

TypeRecord type

Syntax

  |OLD.column_name

Table 11.6OLD Parameters
ParameterDescription

column_name

Column name to access

OLD contains the existing version of a database record just before a deletion or update. Starting with Firebird 2.0 it is read-only.

Note

In multi-action triggers — introduced in Firebird 1.5 — OLD is always available. However, if the trigger is fired by an INSERT, there is obviously no pre-existing version of the record. In that situation, reading from OLD will always return NULL; writing to it will cause a runtime exception.