Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025.
If you would like to use Python UDFs, create the UDFs prior to that date.
Existing Python UDFs will continue to function as normal. For more information, see the
blog post
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)