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_1 — Array of fractional numbers | Array of integers | Array of strings
• array_2 — Array 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.