ARRAYS_OVERLAP

All functions > ARRAY > ARRAYS_OVERLAP

Returns TRUE if any elements are common between the two arrays.

Signatures

Returns: TRUE if arrays share at least one element, FALSE otherwise

ARRAYS_OVERLAP(array1: ARRAY<T>, array2: ARRAY<T>) → BOOLEAN
sql
ParameterTypeRequiredDescription
array1ARRAY<T>YesFirst array to check
array2ARRAY<T>YesSecond array to check

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
Suggest changes to this page
Last update at: 2026/03/03 16:47:38
Last updated: 2026-03-03 16:48:19