CONTAINS (array)

Function CONTAINS is also found in the following categories: String functions.

Syntax

CONTAINS( array, value )

Description

Returns TRUE if array contains value.

Argument types:

  • arrayArray of fractional numbers | Array of integers | Array of strings
  • valueFractional number | Integer | String

Return type: Boolean

Examples

CONTAINS(ARRAY(1, 2, 3), 2) = TRUE
CONTAINS(ARRAY(1, 2, 3), 4) = FALSE

Data source support

ClickHouse 19.13, PostgreSQL 9.3.