Array functions

ARR_AVG

Syntax:ARR_AVG( array )

Returns the average of elements in the array.

ARR_MAX

Syntax:ARR_MAX( array )

Returns the greatest of elements in the array.

ARR_MIN

Syntax:ARR_MIN( array )

Returns the least of elements in the array.

ARR_PRODUCT

Syntax:ARR_PRODUCT( array )

Returns the product of elements in the array.

ARR_STR

Syntax:ARR_STR( array [ , delimiter [ , null_str ] ] )

Concatenates elements of the array array using delimiter as a delimiter (comma by default) and null_str as a NULL string (NULL items are skipped by default).

ARR_SUM

Syntax:ARR_SUM( array )

Returns the sum of elements in the array.

ARRAY

Syntax:ARRAY( value_1, value_2, value_3 [ , ... ] )

Returns an array containing the passed values.

CAST_ARR_FLOAT

Syntax:CAST_ARR_FLOAT( array )

Converts array to an array of fractional numbers. The conversion rules are the same as for FLOAT.

CAST_ARR_INT

Syntax:CAST_ARR_INT( array )

Converts array to an array of integers. The conversion rules are the same as for INT.

CAST_ARR_STR

Syntax:CAST_ARR_STR( array )

Converts array to an array of strings. The conversion rules are the same as for STR.

CONTAINS

Syntax:CONTAINS( array, value )

Returns TRUE if array contains value.

COUNT_ITEM

Syntax:COUNT_ITEM( array, value )

Returns the number of elements in the array array equal to value. The type of value must match the type of the array elements.

GET_ITEM

Syntax:GET_ITEM( array, index )

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

REPLACE

Syntax:REPLACE( array, old, new )

Replaces each array element equal to old with new.

SLICE

Syntax:SLICE( array, offset, length )

Returns the part of array array of length length starting from index offset. Indexes in an array begin with one.

STARTSWITH

Syntax:STARTSWITH( array_1, array_2 )

Returns TRUE if array_1 starts with array_2.

UNNEST

Syntax:UNNEST( array )

Expands the array array expression to a set of rows.

VARP

ARRAY