Numeric version of factorial()

Поиск
Список
Период
Сортировка
От Gavin Sherry
Тема Numeric version of factorial()
Дата
Msg-id Pine.LNX.4.21.0308011020560.12997-200000@linuxworld.com.au
обсуждение исходный текст
Ответы Re: Numeric version of factorial()  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Numeric version of factorial()  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
Attached is a patch implementing factorial(), returning numeric. Points to
note:

1) arttype is numeric. I thought this was the best way of allowing
arbitarily large factorials, even though factorial(2^63) is a large
number. Happy to change to integers if this is overkill.
2) since we're accepting numeric arguments, the patch tests for floats. If
a numeric is passed with non-zero decimal portion, an error is raised
since (from memory) they are undefined.
3) I have not removed factorial([int2|int4|int8]), not their operator
counterparts since I didn't know what people would want done with these.
4) I haven't added any documentation but am happy to once I know if people
want int or numeric arguments.

Thanks,

Gavin

Вложения

В списке pgsql-patches по дате отправления:

Предыдущее
От: Troels Arvin
Дата:
Сообщение: Added comments to postgresql.conf file
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Numeric version of factorial()