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
    f1 := ARRAY_AVG(ARRAY[1, 2, 3, 4]), -- Mean of BIGINT elements
    f2 := ARRAY_AVG(ARRAY[1, NULL::BIGINT, 3]) -- NULL elements excluded from count and sum
;

Edge cases

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