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