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)
