get_array_length function - AWS Clean Rooms
SyntaxArgumentsReturn typeExample

get_array_length function

Returns the length of the specified array. The GET_ARRAY_LENGTH function returns the length of a SUPER array given an object or array path.

Syntax

get_array_length( super_expr )

Arguments

super_expr

A valid SUPER expression of array form.

Return type

The get_array_length function returns a BIGINT.

Example

The following example shows a get_array_length function.

SELECT GET_ARRAY_LENGTH(ARRAY(1,2,3,4,5,6,7,8,9,10));
 get_array_length
----------------------
            10
(1 row)