ALL

<< || (string concatenator) | FB 2.5 Language Reference | ANY / SOME >>
<< || (string concatenator) | FB 2.1 Language Reference | ANY / SOME >>
<< || (string concatenator) | FB 2.0 Language Reference | ANY / SOME >>

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.

See also:
ALL

UNION as subselect

Changed in: 2.0

Description

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

back to top of page
<< || (string concatenator) | FB 2.5 Language Reference | ANY / SOME >>
<< || (string concatenator) | FB 2.1 Language Reference | ANY / SOME >>
<< || (string concatenator) | FB 2.0 Language Reference | ANY / SOME >>