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

Re: [BUGS] BUG #3431: age() gets the days wrong

2007-07-09 Thread Pelle Johansson
Hi Tom, I only have one remark really, which I first thought of after sending the report. If you were to use the result for subtracting from the first value, instead of adding to the second, the conditions are reversed. It's not really as obvious as I first thought whether there's 2 months