ARRAYS_OVERLAP
All functions > ARRAY > ARRAYS_OVERLAP
Returns true if any elements are common between the two arrays.
Syntax
ARRAYS_OVERLAP(array1: ARRAY<T>, array2: ARRAY<T>) → BOOLEANsql
Type Parameters:
T: Any type
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
array1 | ARRAY<T> | Yes | First array to check |
array2 | ARRAY<T> | Yes | Second array to check |
Returns
BOOLEAN - true if arrays share at least one element, false otherwise
Notes
- Returns true if arrays have any common elements
- Returns false if arrays have no common elements
- Empty arrays return false
- Uses element equality comparison