| From: | jian he <jian(dot)universality(at)gmail(dot)com> |
|---|---|
| To: | Joseph Koshakow <koshy44(at)gmail(dot)com> |
| Cc: | Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Infinite Interval |
| Date: | 2022-12-31 05:09:10 |
| Message-ID: | CACJufxFbyVsdGzDEnoTKbfYa=rasCDa8NP5xb-MMd9o4=8V7Hw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Dec 30, 2022 at 10:47 PM Joseph Koshakow <koshy44(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Noah Misch | 2022-12-31 05:36:02 | Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler? |
| Previous Message | Tom Lane | 2022-12-31 04:42:24 | Re: postgres_fdw: using TABLESAMPLE to collect remote sample |