Thanks Tom & Pavel, these are very helpful. On Fri, Jun 25, 2010 at 12:29 PM, Pavel Stehule <pavel.steh...@gmail.com> wrote: > Hello > > 2010/6/25 Lee Hachadoorian <lee.hachadoor...@gmail.com>: >> Is there a function that returns the average of the elements of an >> array? I'm thinking of something that would work like the avg() >> aggregate function where it returns the average of all non-NULL >> values. Can't find anything like it in the docs, and I'd like to make >> sure I'm not missing something. > > it doesn't exists, but it is simple to develop it > > CREATE OR REPLACE FUNCTION array_avg(double precision[]) > RETURNS double precision AS $$ > SELECT avg(v) FROM unnest($1) g(v) > $$ LANGUAGE sql; > > Regards > > Pavel Stehule > >> >> Thanks, >> >> -- >> Lee Hachadoorian >> PhD Student, Geography >> Program in Earth & Environmental Sciences >> CUNY Graduate Center >> >> -- >> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-sql >> >
-- Lee Hachadoorian PhD Student, Geography Program in Earth & Environmental Sciences CUNY Graduate Center -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
