"avg" function for arrays?

From: "G(dot) Anthony Reina" <reina(at)nsi(dot)edu>
To: "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgreSQL(dot)org>
Subject: "avg" function for arrays?
Date: 2001-05-16 19:43:29
Message-ID: 3B02D860.FFB32DD5@nsi.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message George Moga 2001-05-16 19:49:18 Re: Select most recent record?
Previous Message Stephen Patterson 2001-05-16 19:21:22 case insensitive sort for output from SELECT