| Firebird Documentation Index → Firebird 2.5 Language Ref. Update → Operators and predicates → ALL |
![]() |
Table of Contents
Find a more recent version at Firebird 5.0 Language Reference: ALL
Available in: DSQL, ESQL, PSQL
Changed in: 2.0
Description: The ALL predicate now allows a NULL as the
test value. Notice that this brings no practical benefits. In particular, a
NULL test value will not be considered equal to
NULLs in the subquery result set. Even if the entire set is filled
with NULLs and the operator chosen is “=”, the predicate
will not return true, but NULL.
| Firebird Documentation Index → Firebird 2.5 Language Ref. Update → Operators and predicates → ALL |