"avg" function for arrays? - Mailing list pgsql-sql

From G. Anthony Reina
Subject "avg" function for arrays?
Date
Msg-id 3B02D860.FFB32DD5@nsi.edu
Whole thread Raw
List pgsql-sql
I know that there's an "average" function (avg) for some datatypes.
Is there something comparable for float or int arrays?

e.g.
select avg(time_instants[1:5]) from ellipse_proc where rep = 1;            time_instants
-----------------------------------------{"148","167.8","187.6","207.4","227.2"}
(1 row)

select avg(time_instants[1:5]) from ellipse_proc where rep = 1;
ERROR:  Unable to select an aggregate function avg(_float4)

Thanks.
-Tony







pgsql-sql by date:

Previous
From: 山さん
Date:
Subject: Give me a suggestion 'START WITH .. CONNECT BY'.
Next
From: spam@freeuk.com (Stephen Patterson)
Date:
Subject: case insensitive sort for output from SELECT