ALL(...)

All functions > ARRAY > ALL(...)

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

Syntax

ALL(value, value, ...)

ALL(value, value, ...)

Notes

• Returns NULL for empty arrays
• Returns FALSE if any element is false
• NULL values in array will result in NULL return value

See also

• Array functions

Examples

SELECT
    f1 := ALL(true, true, true), -- All true
    f2 := ALL(true, false, true), -- Contains false
    f3 := ALL(false, false, false) -- All false
;