11.13 NEW

Available inPSQL, triggers only

TypeRecord type

Syntax

  1. NEW.column_name

Table 11.13.1 NEW Parameters

ParameterDescription

column_name

Column name to access

NEW contains the new version of a database record that has just been inserted or updated. Starting with Firebird 2.0 it is read-only in AFTER triggers.

Note

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