Re: data statistic functions

On Oct 23, 2007, at 1:43 PM, Kevin Hunter wrote:

> Hullo List,
>
> What does Postgres offer in terms of statistics support (not the
> statistics about the database, but functions to operate on the data).
>
> I know there are simple things like AVG, COUNT, MAX, and MIN, but
> what else?
>
> I'm not sure where to begin looking, other than a cursory
> inspection of
> http://www.postgresql.org/docs/8.3/static/functions.html . . .

Take a look under "Aggregate Functions" ( http://www.postgresql.org/
docs/8.3/static/functions-aggregate.html ). There's probably some
interesting stuff if you look at PL/R too ( http://pgfoundry.org/
projects/plr/ ).

Cheers,
   Steve