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
    -- All true
    f1 := ALL(TRUE, TRUE, TRUE),
    -- Contains false
    f2 := ALL(TRUE, FALSE, TRUE),
    -- All false
    f3 := ALL(FALSE, FALSE, FALSE)
;