numeric stddev_pop and var_pop are wrong

Поиск
Список
Период
Сортировка
От Tom Lane
Тема numeric stddev_pop and var_pop are wrong
Дата
Msg-id 9501.1183991987@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: numeric stddev_pop and var_pop are wrong  (Neil Conway <neilc@samurai.com>)
Список 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 по дате отправления:

Предыдущее
От: Pelle Johansson
Дата:
Сообщение: Re: BUG #3431: age() gets the days wrong
Следующее
От: Neil Conway
Дата:
Сообщение: Re: numeric stddev_pop and var_pop are wrong