CONTAINS_SEQUENCE

All functions > ARRAY > CONTAINS_SEQUENCE

Returns TRUE if the array contains the specified sequence as a contiguous subsequence.

Signatures

Returns: TRUE if sequence appears contiguously in array, FALSE otherwise

CONTAINS_SEQUENCE(array: ARRAY<T>, sequence: ARRAY<T>) → BOOLEAN
sql
ParameterTypeRequiredDescription
arrayARRAY<T>YesThe array to search within
sequenceARRAY<T>YesThe contiguous sequence to find

Notes

  • Checks for contiguous subsequence match
  • Elements must appear in order without gaps
  • Returns FALSE if sequence is not found
  • Returns TRUE for empty sequence
  • 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