Re: Infinite Interval

Поиск
Список
Период
Сортировка
От jian he
Тема Re: Infinite Interval
Дата
Msg-id CACJufxFbyVsdGzDEnoTKbfYa=rasCDa8NP5xb-MMd9o4=8V7Hw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Infinite Interval  (Joseph Koshakow <koshy44@gmail.com>)
Ответы Re: Infinite Interval  (Vik Fearing <vik@postgresfriends.org>)
Re: Infinite Interval  (Joseph Koshakow <koshy44@gmail.com>)
Список pgsql-hackers
Дерево обсуждения


On Fri, Dec 30, 2022 at 10:47 PM Joseph Koshakow <koshy44@gmail.com> wrote:
I have another update, I cleaned up some of the error messages, fixed
the horology tests, and ran pgindent.

- Joe

Hi, there.

Since in float8 you can use '+inf', '+infinity', So should we also make interval '+infinity' valid?
Also in timestamp. '+infinity'::timestamp is invalid, should we make it valid.

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).


  I recommend David Deutsch's <<The Beginning of Infinity>>

  Jian


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: postgres_fdw: using TABLESAMPLE to collect remote sample
Следующее
От: Noah Misch
Дата:
Сообщение: Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler?