NEW
<< INSERTING | FB 2.5 Language Reference | 'NOW' >>
<< INSERTING | FB 2.1 Language Reference | 'NOW' >>
<< INSERTING | FB 2.0 Language Reference | 'NOW' >>
NEW
Available in: PSQL, triggers only
Changed in: 1.5, 2.0
Description
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.
Type: Data row
Note: In multi-action triggers – introduced in Firebird 1.5 – NEW is always available. But 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.
back to top of page
<< INSERTING | FB 2.5 Language Reference | 'NOW' >>
<< INSERTING | FB 2.1 Language Reference | 'NOW' >>
<< INSERTING | FB 2.0 Language Reference | 'NOW' >>
