Amazon Redshift will no longer support the creation of new Python UDFs starting Patch 198. Existing Python UDFs will continue to function until June 30, 2026. For more information, see the [ blog post ](https://aws.amazon.com/blogs/big-data/amazon-redshift-python-user-defined-functions-will-reach-end-of-support-after-june-30-2026/). 

# SUBARRAY function
<a name="r_subarray"></a>

Extracts a portion of an array starting from a specified position. Returns a new array containing the specified number of elements from the input array.

## Syntax
<a name="r_subarray-syntax"></a>

```
SUBARRAY( super_expr, start_position, length )
```

## Arguments
<a name="r_subarray-arguments"></a>

*super\$1expr*  
A valid SUPER expression in array form.

*start\$1position*  
An integer that specifies the starting position for extraction. The index is 0-based, where 0 indicates the first element. If start\$1position is beyond the array length, an empty array is returned.

*length*  
An optional integer that specifies the number of elements to extract. If omitted, all elements from the start position to the end of the array are returned.

## Return type
<a name="r_subarray-return-type"></a>

The SUBARRAY function returns a SUPER data value.

## Examples
<a name="r_subarray-examples"></a>

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)
```

## See also
<a name="r_subarray-see-also"></a>
+ [ARRAY\$1POSITION function](array_position.md)
+ [ARRAY\$1POSITIONS function](array_positions.md)
+ [ARRAY\$1FLATTEN function](array_flatten.md)
+ [ARRAY\$1CONCAT function](r_array_concat.md)