Re: Infinite Interval

Поиск
Список
Период
Сортировка
От Joseph Koshakow
Тема Re: Infinite Interval
Дата
Msg-id CAAvxfHfe=qnE3hRpqmnbd2Mh2V9jZPZzomfWJ5xyYo0kfpwrSg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Infinite Interval  (jian he <jian.universality@gmail.com>)
Ответы Re: Infinite Interval  (Joseph Koshakow <koshy44@gmail.com>)
Список pgsql-hackers
On Sat, Dec 31, 2022 at 12:09 AM jian he <jian.universality@gmail.com> wrote:
> In float8, select float8 'inf' / float8 'inf' return NaN. Now in your patch  select interval 'infinity' / float8
'infinity';returns infinity.
 
> I am not sure it's right. I found this related post
(https://math.stackexchange.com/questions/181304/what-is-infinity-divided-by-infinity).

Good point, I agree this should return an error. We also need to
properly handle multiplication and division of infinite intervals by
float8 'nan'. My patch is returning an infinite interval, but it should
be returning an error. I'll upload a new patch shortly.

- Joe



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row
Следующее
От: Dean Rasheed
Дата:
Сообщение: Re: MERGE ... WHEN NOT MATCHED BY SOURCE