Re: BUG #17876: Function width_bucket() for float8 input returns value out of range

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #17876: Function width_bucket() for float8 input returns value out of range
Дата
Msg-id 2173637.1680730866@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #17876: Function width_bucket() for float8 input returns value out of range  (Mats Kindahl <mats@timescale.com>)
Список pgsql-bugs
Mats Kindahl <mats@timescale.com> writes:
> On Fri, Mar 31, 2023 at 3:14 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> While I'm not bothered too much if rounding affects which internal
>> bucket a value lands in, it's a bit more annoying if that causes
>> it to be reported as being in the end bucket, when we know positively
>> that the value is less than bound2.  Is it worth expending more
>> cycles to prevent this?

> I think it could be. I agree that it does not make sense to select the end
> bucket when the value is in range, even if just.

Yeah.  I did that already at a2a0c7c29, sorry for not circling back
to this thread.

            regards, tom lane



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

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: Wrong results with postgres_fdw and merge anti join from RHEL 7.9 to RHEL 8.7
Следующее
От: Edi Keškić
Дата:
Сообщение: Error while installing Postgresql