Re: [GENERAL] data statistic functions

2007-10-23 Thread Tom Lane
Kevin Hunter <[EMAIL PROTECTED]> writes: > On a side note, I also noted that I couldn't immediately spot AVG, MAX, > or MIN in the output of \df. \df explicitly excludes aggregate functions. Try \da. regards, tom lane ---(end of broadcast)

Re: [GENERAL] data statistic functions

2007-10-23 Thread Kevin Hunter
At 4:53p -0400 on 23 Oct 2007, Steve Atkins wrote: > There's probably some interesting stuff if you look at PL/R too ( > http://pgfoundry.org/projects/plr/ ). PL/R . . . that looks promising. Thanks. Kevin ---(end of broadcast)--- TIP 3: Have you

Re: [GENERAL] data statistic functions

2007-10-23 Thread Steve Atkins
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 whe

Re: [GENERAL] data statistic functions

2007-10-23 Thread Joshua D. Drake
On Tue, 23 Oct 2007 16:43:04 -0400 Kevin Hunter <[EMAIL PROTECTED]> 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,

[GENERAL] data statistic functions

2007-10-23 Thread Kevin Hunter
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