Re: gamma() and lgamma() functions - Mailing list pgsql-hackers

From Stepan Neretin
Subject Re: gamma() and lgamma() functions
Date
Msg-id CAN-sa+BiLPkG4HSMdUFA6xYgHf3zxnA56bC87bQw_iyehtoyDg@mail.gmail.com
Whole thread Raw
In response to gamma() and lgamma() functions  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: gamma() and lgamma() functions
List pgsql-hackers


On Mon, Jul 1, 2024 at 5:33 PM Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
Attached is a patch adding support for the gamma and log-gamma
functions. See, for example:

https://en.wikipedia.org/wiki/Gamma_function

I think these are very useful general-purpose mathematical functions.
They're part of C99, and they're commonly included in other
mathematical libraries, such as the python math module, so I think
it's useful to make them available from SQL.

The error-handling for these functions seems to be a little trickier
than most, so that might need further discussion.

Regards,
Dean

I tried to review the patch without applying it. It looks good to me, but I have one notice:
ERROR:  value out of range: overflow. I think we need to add information about the available ranges in the error message

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Should we document how column DEFAULT expressions work?
Next
From: Alvaro Herrera
Date:
Subject: Re: LogwrtResult contended spinlock