Re: data statistic functions

On Tue, 23 Oct 2007 16:43:04 -0400
Kevin Hunter <hunteke(at)earlham(dot)edu> 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 . . .
>
> On a side note, I also noted that I couldn't immediately spot AVG,
> MAX, or MIN in the output of \df.

http://www.postgresql.org/docs/8.2/static/functions-aggregate.html

Sincerely,

Joshua D. Drake

>
> Thanks,
>
> Kevin
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 2: Don't 'kill -9' the
> postmaster
>

--

=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/