Re: BUG #4916: wish: more statistical functions (median, percentiles etc)

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