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.