ARRAY_SUM()

All functions > ARRAY > ARRAY_SUM()

Returns the sum of all numeric elements in an array.

Signatures

Returns: The sum of all numeric elements in the array

ARRAY_SUM(array: ARRAY<T>) → T

Notes

• Adds all numeric values in the array
• Ignores NULL values (they do not contribute to the sum)
• Returns NULL for empty arrays
• Handles negative values correctly
• May overflow for very large sums
• Only works with numeric arrays

See also

• Array functions

Examples

SELECT
    f1 := ARRAY_SUM(ARRAY[1, 2, 3]), -- Basic sum
    f2 := ARRAY_SUM(ARRAY[1, NULL::BIGINT, 2]), -- NULL elements ignored in sum
    f3 := ARRAY_SUM(ARRAY[]::BIGINT[]) -- Empty array
;