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
Re: Infinite Interval |
| Список | 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.
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).
Jian
В списке pgsql-hackers по дате отправления: