STARTSWITH (array)

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

    Syntax

    STARTSWITH( array_1, array_2 )
    

    Description

    Returns TRUE if array_1 starts with 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

    Examples

    STARTSWITH(ARRAY(1, 2, 3), ARRAY(1, 2)) = TRUE
    
    STARTSWITH(ARRAY(1, 2, 3), ARRAY(2, 3)) = FALSE
    

    Data source support

    ClickHouse 19.13, PostgreSQL 9.3.