subarray function

Manipulates arrays to return a subset of the input arrays.

Syntax

SUBARRAY( super_expr, start_position, length )

Arguments

super_expr

A valid SUPER expression in array form.

start_position

The position within the array to begin the extraction, starting at index position 0. A negative position counts backward from the end of the array.

length

The number of elements to extract (the length of the substring).

Return type

The subarray function returns a SUPER data value.

Examples

The following is an example of a subarray function.

 SELECT SUBARRAY(ARRAY('a', 'b', 'c', 'd', 'e', 'f'), 2, 3);
   subarray
---------------
 ["c","d","e"]
(1 row)