Re: aggregate function stddev - Mailing list pgsql-sql

From Josh Berkus
Subject Re: aggregate function stddev
Date
Msg-id 200409091137.19204.josh@agliodbs.com
Whole thread Raw
In response to aggregate function stddev  (Kemin Zhou <kemin.zhou@ferring.com>)
Responses Re: aggregate function stddev  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
Kemin,

> Just noticed that the postgres stddev is the stddev_sample formula.
> There are two different ways to calculate this value.
> Their difference is very small with large samle size.  It would be nice
> to distinguish the two different versions.

Note sent to PGSQL-DOCS.

> I also noticed that oracle has stddev_sample and stddev_population.
> This is just a wish list.

Were you aware that in PostgreSQL you can write your own aggregates?   It's 
relatively easy to do.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco


pgsql-sql by date:

Previous
From: "Passynkov, Vadim"
Date:
Subject: Re: Isnumeric function?
Next
From: Josh Berkus
Date:
Subject: Re: Datetime conversion in WHERE clause