Skip to main content
Version: 24.3.x

Categories: Aggregate, Semi-Structured Data

ARRAY_AVG

Returns the average of all non-null elements of a list.

Syntax

ARRAY_AVG(list_column LIST) → numeric

  • list_column: Column that contains a LIST expression. Every element of the list must be a number such as INT, BIGINT, FLOAT4, FLOAT8, or DECIMAL. Cannot be an array literal.

Examples

array_col contains ARRAY[1, 2, 3]
SELECT ARRAY_AVG(array_col)
-- 2
array_col contains ARRAY[2,4,null]
SELECT ARRAY_AVG(array_col)
-- 3
array_col contains ARRAY[]
SELECT ARRAY_AVG(array_col)
-- NULL
array_col contains ARRAY[null]
SELECT ARRAY_AVG(array_col)
-- NULL
array_col contains null
SELECT ARRAY_AVG(array_col)
-- NULL

Usage Notes

The return type is T given an input ARRAY<T>. If the parameter is NULL, this function returns NULL. If there are no non-null elements in the parameter, this function returns 0.