how to calculate standard deviation from a table

From: Pierre Hsieh <pierre(dot)hsieh(at)gmail(dot)com>
To: Brian Dunavant <brian(at)omniti(dot)com>, Rémi Cura <remi(dot)cura(at)gmail(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org>, rod <rod(at)iol(dot)ie>, Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>
Subject: how to calculate standard deviation from a table
Date: 2015-01-22 15:18:32
Message-ID: CADT0GeuJgYQzQv5iQr11r_KaGZAbqwX3Kb5FdZS858imbFLjuw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

This table just has a column which type is integer. There are one million
data in this table. I wanna calculate standard deviation on each 50 data by
order. It means SD1 is from data 1 to data 50, SD2 is from data 51 to
100.... Is there anyone who can give me some suggestions? Thanks

Pierre

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-01-22 15:21:56 Re: implicit cast works for insert, not for select
Previous Message Michael Paquier 2015-01-22 15:03:34 Re: How to create a specific table