Re: BUG #4916: wish: more statistical functions (median, percentiles etc) - Mailing list pgsql-bugs

From Joshua Tolley
Subject Re: BUG #4916: wish: more statistical functions (median, percentiles etc)
Date
Msg-id 20090711005234.GC31174@eddie
Whole thread Raw
In response to BUG #4916: wish: more statistical functions (median, percentiles etc)  ("Richard Neill" <rn214@cam.ac.uk>)
Responses Re: BUG #4916: wish: more statistical functions (median, percentiles etc)
List pgsql-bugs
On Fri, Jul 10, 2009 at 11:37:46PM +0000, Richard Neill wrote:
> In addition to the existing aggregate functions (avg, stddev etc),  it wo=
uld
> be nice if postgres could return further information. For example, the
> quartiles, percentiles, and median.=20=20
>=20
> [mode would also be useful, as an explicit function, though we can get it
> easily enough using count(1) order by count desc].
>=20
> According to google, this has been a wish since at least year 2000 for
> various people, but doesn't seem to be implemented.=20

That's because no one has yet taken the time. However, patches are welcome,=
 if
you'd like it enough to implement it. It's on my list of things that might =
be
interesting to write, for example, but there are other things higher up on
that list.

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

pgsql-bugs by date:

Previous
From: "Richard Neill"
Date:
Subject: BUG #4916: wish: more statistical functions (median, percentiles etc)
Next
From: Joshua Tolley
Date:
Subject: Re: BUG #4916: wish: more statistical functions (median, percentiles etc)