Firebird Documentation Index → Firebird 2.0.6 Release Notes → New in Firebird 2.0 → UDFs Improved re NULL Handling |
Ability to signal SQL NULL via a NULL pointer (see Signal SQL NULL in UDFs).
External function library ib_udf upgraded to allow the string functions ASCII_CHAR, LOWER, LPAD, LTRIM, RPAD, RTIM, SUBSTR and SUBSTRLEN to return NULL and have it interpreted correctly.
The script ib_udf_upgrade.sql
can be applied to pre-v.2 databases that have these
functions declared, to upgrade them to work with the upgraded library. This script should be used only when
you are using the new ib_udf library with Firebird v2 and operation requests are modified to anticipate
nulls.
Firebird Documentation Index → Firebird 2.0.6 Release Notes → New in Firebird 2.0 → UDFs Improved re NULL Handling |