Postgres Pro
Downloads
Home   >   mailing lists

Average of Array? - Mailing list pgsql-sql

From Lee Hachadoorian
Subject Average of Array?
Date
Msg-id AANLkTimbLPhLW7DzeTugvwClKBX-UQhOrUlR8afHydGB@mail.gmail.com
Whole thread Raw
Responses Re: Average of Array?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Average of Array?  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Average of Array?  (Ireneusz Pluta <ipluta@wp.pl>)
List pgsql-sql
Tree view 
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.

Thanks,

-- 
Lee Hachadoorian
PhD Student, Geography
Program in Earth & Environmental Sciences
CUNY Graduate Center

pgsql-sql by date:

Previous
From: "bruno.scovoli"
Date:
Subject: Re: COPY command and required file permissions
Next
From: Tom Lane
Date:
Subject: Re: Average of Array?