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.

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)