Lambda functions
ARRAY_ALL_MATCH
Reference material for ARRAY_ALL_MATCH function
- Returns
TRUE
if all elements in the array areTRUE
or if the array is empty. - Returns
FALSE
if any element in the array isFALSE
. - Returns
NULL
if any element isNULL
and no element isFALSE
.
When an optional lambda function is provided, ARRAY_ALL_MATCH
applies the function to each element and then evaluates the resulting array.
Alias: ALL_MATCH
Syntax
Parameters
Parameter | Description | Supported input types |
---|---|---|
<expression> | A lambda function applied to each element of the input arrays, returning a BOOLEAN . If no lambda function is provided, the function can only evaluate a single BOOLEAN array. For more information, see Manipulating arrays with Lambda functions. | Same as the element data types of the input arrays. |
<condition> | A BOOLEAN expression that evaluates each array value using a comparison operator. | See Comparison operators. |
<array> | The array to evaluate. | ARRAY |
Return Type
The ARRAY_ALL_MATCH
function returns a result of type BOOLEAN
.
Examples
Check if all player nicknames end with '2024'
:
result (BOOLEAN) |
---|
t |
Check if all elements in the first array can be divided by the elements in the second array:
divisable (BOOLEAN) |
---|
t |
Check if all elements in an input array are true
:
empty (BOOLEAN) | single_true (BOOLEAN) | single_false (BOOLEAN) | single_null (BOOLEAN) | false_and_null (BOOLEAN) |
---|---|---|---|---|
t | t | f | NULL | f |