Fwd: [SQL] aggregate function stddev

Started by Josh Berkusover 21 years ago2 messagesdocs
Jump to latest
#1Josh Berkus
josh@agliodbs.com

Folks,

Sending this remark to the list so that I/we don't forget to patch it .....

========================================
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.
========================================

--
Josh Berkus
Aglio Database Solutions
San Francisco

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Josh Berkus (#1)
Re: Fwd: [SQL] aggregate function stddev

Josh Berkus <josh@agliodbs.com> writes:

Sending this remark to the list so that I/we don't forget to patch it .....

========================================
Just noticed that the postgres stddev is the stddev_sample formula.

The documentation already points out that stddev is the sample standard
deviation.

regards, tom lane