ALL_FUNC
All functions > ARRAY > ALL_FUNC
Returns true if all elements in the boolean array are true.
Syntax
ALL_FUNC(array)sql
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
array | ARRAYBOOLEAN | Yes | Array of boolean values to check |
Returns
BOOLEAN - true if all elements are true, false otherwise, NULL for empty arrays
Notes
- Returns NULL for empty arrays
- Returns false if any element is false
- Can be used with operator syntax: ALL(val1, val2, val3)
- NULL values in array will result in NULL return value
Aliases
ARRAY_ALL