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
NULL
s in the subquery result set. Even if the entire set is filled
with NULL
s 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 |