Postgres Pro
Downloads
Home   >   mailing lists

how to calculate standard deviation from a table - Mailing list pgsql-general

From Pierre Hsieh
Subject how to calculate standard deviation from a table
Date
Msg-id CADT0GeuJgYQzQv5iQr11r_KaGZAbqwX3Kb5FdZS858imbFLjuw@mail.gmail.com
Whole thread Raw
Responses Re: how to calculate standard deviation from a table  (David G Johnston <david.g.johnston@gmail.com>)
Re: how to calculate standard deviation from a table  (Paul Jungwirth <pj@illuminatedcomputing.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: How to create a specific table
Next
From: Adrian Klaver
Date:
Subject: Re: implicit cast works for insert, not for select