Folks,
For those of you who can't attend in person, we'll be streaming audio
and video and having a chat for tonight's SFPUG meeting on how the
planner uses statistics.
Video:
http://media.postgresql.org/sfpug/streaming
Chat:
irc://irc.freenode.net/sfpug
Cheers,
David.
--
David Fetter
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:
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.
Thanks,
Hrishi
---(end of
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
; i size; i++)
cout i th item is RandomSelect(data, 0, size - 1,
i) endl;
return 0;
}
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Hrishikesh
Deshmukh
Sent: Friday, March 18, 2005 10:37 AM
To: Postgresql-General
Subject: [GENERAL
/* On the test stub: */
[snip]
double data[30];
int main(void)
{
size_t i;
size_t size = sizeof(data) / sizeof(data[0]);
for (i = 0; i size; i++) {
data[i] = rand();
}
for (i = 0; i size; i++) {
cout data[i] endl;