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.