array_flatten function - Amazon Redshift
SyntaxArgumentsReturn typeExample

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 .

array_flatten function

Merges multiple arrays into a single array of SUPER type.

Syntax

array_flatten( super_expr1,super_expr2,.. )

Arguments

super_expr1,super_expr2

A valid SUPER expression of array form.

Return type

The array_flatten function returns a SUPER data value.

Example

The following example shows an array_flatten function. 

SELECT ARRAY_FLATTEN(ARRAY(ARRAY(1,2,3,4),ARRAY(5,6,7,8),ARRAY(9,10)));
     array_flatten
------------------------
 [1,2,3,4,5,6,7,8,9,10]
(1 row)