Firebird Documentation Index → Firebird 2.1 Language Ref. Update → Operators and predicates → ANY / SOME
Firebird Home Firebird Home Prev: ALLFirebird Documentation IndexUp: Operators and predicatesNext: IN

ANY / SOME

Table of Contents

NULL literals allowed
UNION as subselect

Tip

Find a more recent version at Firebird 5.0 Language Reference: ANY and SOME

Available in: DSQL, ESQL, PSQL

NULL literals allowed

Changed in: 2.0

Description: The ANY (or SOME) 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 a NULL in the subquery result set.

UNION as subselect

Changed in: 2.0

Description: The subselect in an ANY (or SOME) predicate may now also be a UNION.

Prev: ALLFirebird Documentation IndexUp: Operators and predicatesNext: IN
Firebird Documentation Index → Firebird 2.1 Language Ref. Update → Operators and predicates → ANY / SOME