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.

Previous
Next