numeric stddev_pop and var_pop are wrong - Mailing list pgsql-bugs

From Tom Lane
Subject numeric stddev_pop and var_pop are wrong
Date
Msg-id 9501.1183991987@sss.pgh.pa.us
Whole thread Raw
Responses Re: numeric stddev_pop and var_pop are wrong  (Neil Conway <neilc@samurai.com>)
List pgsql-bugs
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 regression test outputs for the function, so those
outputs weren't checked very carefully :-(

            regards, tom lane

pgsql-bugs by date:

Previous
From: Pelle Johansson
Date:
Subject: Re: BUG #3431: age() gets the days wrong
Next
From: Neil Conway
Date:
Subject: Re: numeric stddev_pop and var_pop are wrong