subarray function - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

subarray function

Manipulates arrays to return a subset of the input arrays.


SUBARRAY( super_expr, start_position, length )



A valid SUPER expression in array form.


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.


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

Return type

The subarray function returns a SUPER data value.


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)