IN

<< ANY / SOME | FB 2.5 Language Reference | IS [NOT] DISTINCT FROM >>
<< ANY / SOME | FB 2.1 Language Reference | IS [NOT] DISTINCT FROM >>
<< ANY / SOME | FB 2.0 Language Reference | IS [NOT] DISTINCT FROM >>

IN

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

The subselect in an IN predicate may now also be a UNION.

See also:
IN operator

back to top of page
<< ANY / SOME | FB 2.5 Language Reference | IS [NOT] DISTINCT FROM >>
<< ANY / SOME | FB 2.1 Language Reference | IS [NOT] DISTINCT FROM >>
<< ANY / SOME | FB 2.0 Language Reference | IS [NOT] DISTINCT FROM >>