CONTAINS_ALL

Syntax

CONTAINS_ALL( array_1, array_2 )

Description

Returns TRUE if array_1 contains all elements of array_2.

Argument types:

  • array_1Array of fractional numbers | Array of integers | Array of strings
  • array_2Array of fractional numbers | Array of integers | Array of strings

Return type: Boolean

Example

[array1] [array2] CONTAINS_ALL([array1], [array2])
'[1,2,3]' '[1,2]' True
'[1,2,3]' '[1,4]' False

Data source support

ClickHouse 21.8, PostgreSQL 9.3.