Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateOperators and predicates → IN
Firebird Home Firebird Home Prev: ANY / SOMEFirebird Documentation IndexUp: Operators and predicatesNext: IS [NOT] DISTINCT FROM

IN

NULL literals allowed
UNION as subselect

Available in: DSQL, ESQL, PSQL

NULL literals allowed

Changed in: 2.0

Description: The IN predicate now allows NULL literals, both as the test value and in the list. Notice that this brings no practical benefits. In particular, “NULL IN (..., NULL, ..., ...)” will not return true and “NULL NOT IN (..., NULL, ..., ...)” will not return false.

UNION as subselect

Changed in: 2.0

Description: A subselect in an IN predicate may now also be a UNION.

Prev: ANY / SOMEFirebird Documentation IndexUp: Operators and predicatesNext: IS [NOT] DISTINCT FROM
Firebird Documentation IndexFirebird 2.0 Language Ref. UpdateOperators and predicates → IN