ANY(...)

All functions > ARRAY > ANY(...)

Returns TRUE if any element in the boolean array is true.

Syntax

ANY(value, value, ...)

ANY(value, value, ...)

Notes

• Returns NULL for empty arrays
• Returns TRUE if at least one element is true
• NULL values in array will result in NULL return value

See also

• Array functions

Examples

SELECT
    f1 := ANY(true, true, true), -- Contains true
    f2 := ANY(true, false, true), -- At least one true
    f3 := ANY(false, false, false) -- No true elements
;