Re: [BUGS] numeric stddev_pop and var_pop are wrong

2007-07-09 Thread Neil Conway
On Mon, 2007-09-07 at 10:39 -0400, Tom Lane wrote: > When applied to "numeric" input, stddev_pop produces the same result as > stddev_samp, and var_pop produces the same result as var_samp. This > is because whoever wrote numeric_stddev_internal() forgot that the > divisor is different for the sam

[BUGS] numeric stddev_pop and var_pop are wrong

2007-07-09 Thread Tom Lane
When applied to "numeric" input, stddev_pop produces the same result as stddev_samp, and var_pop produces the same result as var_samp. This is because whoever wrote numeric_stddev_internal() forgot that the divisor is different for the sample case. This mistake is in fact visible in the regressio