Re: Numeric x^y for negative x
От | Zhihong Yu |
---|---|
Тема | Re: Numeric x^y for negative x |
Дата | |
Msg-id | CALNJ-vTrm4Ci3uVG5g_pWF0VFYTh2pUH4BFBTfgWvNH2uve-Hw@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Numeric x^y for negative x (Dean Rasheed <dean.a.rasheed@gmail.com>) |
Ответы |
Re: Numeric x^y for negative x
|
Список | pgsql-hackers |
On Wed, Jul 7, 2021 at 10:37 AM Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
On Thu, 1 Jul 2021 at 14:17, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
>
> On Tue, 29 Jun 2021 at 12:08, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
> >
> > Numeric x^y is supported for x < 0 if y is an integer, but this
> > currently fails if y is outside the range of an int32
>
> I've been doing some more testing of this, and I spotted another
> problem with numeric_power().
>
> [loss of precision and overflow errors]
>
> I think we should attempt to avoid all such overflow errors,
> that are actually underflows, and return zero instead.
>
Finally getting back to this ... attached is an updated patch that now
includes a fix for the loss-of-precision bug and the overflow errors.
I don't think it's really worth trying to split these up, since
they're all somewhat interrelated.
Regards,
Dean
Hi,
+ errmsg("value overflows numeric format")));
Here is an example of existing error message which I think is more readable than 'overflows numeric format':
errmsg("bigint out of range")));
Maybe rephrase as: value is out of range
Cheers
В списке pgsql-hackers по дате отправления: