ARRAY_AVG()

All functions > ARRAY > ARRAY_AVG()

Returns the arithmetic mean (average) of all numeric elements in an array.

Signatures

Returns: The arithmetic mean as a DOUBLE value

ARRAY_AVG(array: ARRAY<T>) → DOUBLE

Notes

• Calculates sum divided by count of non-NULL values
• Ignores NULL values in the calculation
• Always returns DOUBLE regardless of input type
• Returns NULL for empty arrays or arrays with only NULL values
• Uses floating-point arithmetic for precision

See also

• Array functions

Examples

Typical averages

SELECT
    -- Mean of BIGINT elements
    f1 := ARRAY_AVG(ARRAY(1, 2, 3, 4)),
    -- NULL elements excluded from count and sum
    f2 := ARRAY_AVG(ARRAY(1, NULL::BIGINT, 3))
;

Edge cases

SELECT
    -- Empty array → NULL
    f1 := ARRAY_AVG(ARRAY()::BIGINT[])
;