Re: Bug #534: factorial function
От | Tom Lane |
---|---|
Тема | Re: Bug #534: factorial function |
Дата | |
Msg-id | 23148.1008002264@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: Bug #534: factorial function (Thomas Lockhart <lockhart@fourpalms.org>) |
Ответы |
Re: Bug #534: factorial function
|
Список | pgsql-bugs |
Thomas Lockhart <lockhart@fourpalms.org> writes: >> ... I'd be sorely tempted to replace all three by a single >> function that takes integer and returns numeric. > Yikes. Although numeric is theoretically nice, it is hundreds of times > slower than native doubles. (a) As a wise man once said, "I can make it arbitrarily fast, if it doesn't have to give the right answer". (b) The factorial function doesn't strike me as a performance bottleneck. (c) I have no objection to offering a double-precision-based gamma function alongside the integer factorial function. But I think factorial should give an exact answer as far as is possible before it overflows. regards, tom lane
В списке pgsql-bugs по дате отправления: