Re: how to calculate standard deviation from a table

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: how to calculate standard deviation from a table
Date: 2015-01-22 15:49:13
Message-ID: 1421941753853-5835042.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pierre Hsieh wrote
> 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

Integer division

David J.

--
View this message in context: http://postgresql.nabble.com/how-to-calculate-standard-deviation-from-a-table-tp5835031p5835042.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Jungwirth 2015-01-22 16:28:06 Re: how to calculate standard deviation from a table
Previous Message Tom Lane 2015-01-22 15:44:26 Re: temporary tables are logged somehow?