GET_ITEM

Syntax

GET_ITEM( array, index )

Description

Returns the element with the index index from the array array. Index must be any integer. Indexes in an array begin with one.

Argument types:

  • arrayArray of fractional numbers | Array of integers | Array of strings
  • indexInteger

Return type: Depends on argument types

Example

GET_ITEM([array_field], 2)

Data source support

ClickHouse 19.13, PostgreSQL 9.3.

Previous