ANY / SOME

(redirected from Doc.SOME)

<< ALL | FB 2.5 Language Reference | IN >>
<< ALL | FB 2.1 Language Reference | IN >>
<< ALL | FB 2.0 Language Reference | IN >>

ANY / 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.

back to top of page
<< ALL | FB 2.5 Language Reference | IN >>
<< ALL | FB 2.1 Language Reference | IN >>
<< ALL | FB 2.0 Language Reference | IN >>