| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Hrishikesh Deshmukh <hdeshmuk(at)gmail(dot)com> |
| Cc: | Postgresql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Statistics with PostgreSQL |
| Date: | 2005-03-18 18:47:45 |
| Message-ID: | 20050318184744.GA848@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Mar 18, 2005 at 01:37:10PM -0500, Hrishikesh Deshmukh wrote:
> Hi All,
>
> Is there a way to simple statistics like mean/median/mode in
> PostgreSQL. I have tables like PsetID | IntensityValue. I want to
> find out mean (intensityValue) of some PsetID(s)?!
> Any urls/pointers/books would be a big help.
Hrishi,
For statistics beyond avg() and stddev(), check out PL/R
http://www.joeconway.com/plr/
Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778
Remember to vote!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dann Corbit | 2005-03-18 19:00:20 | Re: Statistics with PostgreSQL |
| Previous Message | Hrishikesh Deshmukh | 2005-03-18 18:37:10 | Statistics with PostgreSQL |