Re: Statistics with PostgreSQL

Поиск
Список
Период
Сортировка
Искать
От
Brent Wood
Тема
Re: Statistics with PostgreSQL
Дата
Msg-id
20050321101558.R41216@storm-user.niwa.co.nz
Ответ на
Список
Дерево обсуждения
Re: Statistics with PostgreSQL "Dann Corbit" <DCorbit@connx.com>


> 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 по дате отправления
От: Sarah Ewen
Дата:
От: Woodchuck Bill
Дата:
FAQ