Firebird Documentation IndexFirebird 2.1 Language Ref. UpdateOperators and predicates → ALL
Firebird Home Firebird Home Prev: || (string concatenator)Firebird Documentation IndexUp: Operators and predicatesNext: ANY / SOME

ALL

Table of Contents

NULL literals allowed
UNION as subselect

Tip

Find a more recent version at Firebird 5.0 Language Reference: ALL

Available in: DSQL, ESQL, PSQL

NULL literals allowed

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.

UNION as subselect

Changed in: 2.0

Description: The subselect in an ALL predicate may now also be a UNION.

Prev: || (string concatenator)Firebird Documentation IndexUp: Operators and predicatesNext: ANY / SOME
Firebird Documentation IndexFirebird 2.1 Language Ref. UpdateOperators and predicates → ALL