STARTSWITH (array)

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

SyntaxSyntax

STARTSWITH( array_1, array_2 )

DescriptionDescription

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

ExamplesExamples

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

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

Data source supportData source support

ClickHouse 21.8, PostgreSQL 9.3.