| Firebird Documentation Index → Firebird 2.1 Language Ref. Update → Operators and predicates → 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.1 Language Ref. Update → Operators and predicates → ALL |