ARRAY_SUM

Reference material for ARRAY_SUM function

Returns the sum of elements of <array>.

Syntax

ARRAY_SUM(<array>)

Parameters

Parameter	Description	Supported input types
<array>	The array to be used to calculate the function.	Any array of numeric types

Return Type

The return type depends on the input type:

Array element type	Return type
INTEGER	BIGINT
BIGINT	NUMERIC(38, 0)
NUMERIC(precision, scale)	NUMERIC(precision, scale)
REAL	REAL
DOUBLE	DOUBLE

Example

SELECT ARRAY_SUM([4, 1, 3, 2]) AS levels;

levels long null
10

Rows: 1Execution time: 5.79ms