NONE(...)

All functions > ARRAY > NONE(...)

Returns TRUE if no elements in the boolean array are true.

Syntax

NONE(value, value, ...)

NONE(value, value, ...)

Notes

• NULL elements are ignored
• Returns TRUE when every non-NULL element is FALSE
• Returns FALSE when any non-NULL element is TRUE
• An array whose elements are all NULL is TRUE, the empty set after the NULL skip
• Returns TRUE for an empty array (vacuous truth). NOT ANY of an empty array is NULL, so NONE is not NOT ANY

See also

• Array functions

Examples

RETURN
    -- Contains true
    f1 := NONE(TRUE, TRUE, TRUE),
    -- Contains true
    f2 := NONE(TRUE, FALSE, TRUE),
    -- No true elements
    f3 := NONE(FALSE, FALSE, FALSE)
;