Re: Statistics with PostgreSQL - Mailing list pgsql-general

From Brent Wood
Subject Re: Statistics with PostgreSQL
Date
Msg-id 20050321101558.R41216@storm-user.niwa.co.nz
Whole thread Raw
In response to Re: Statistics with PostgreSQL  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-general

> Mean is just sum(col)/count(col)

You can also just use avg(col).

Either way, be careful because nulls may not be treated as you want for
such calculations.

The stats package R can access Postgres databases, and can be used for
robust statistical analyses of the data.

See:
http://sourceforge.net/projects/rdbi/


Cheers,

  Brent Wood

pgsql-general by date:

Previous
From: Sarah Ewen
Date:
Subject: pg_dump fails with socket_not_open
Next
From: Woodchuck Bill
Date:
Subject: Re: 3rd RFD: comp.databases.postgresql (was: comp.databases.postgresql.*)