| From: | Joseph Koshakow <koshy44(at)gmail(dot)com> |
|---|---|
| To: | jian he <jian(dot)universality(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: | 2023-01-02 18:21:50 |
| Message-ID: | CAAvxfHfe=qnE3hRpqmnbd2Mh2V9jZPZzomfWJ5xyYo0kfpwrSg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, Dec 31, 2022 at 12:09 AM jian he <jian(dot)universality(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dean Rasheed | 2023-01-02 18:24:10 | Re: MERGE ... WHEN NOT MATCHED BY SOURCE |
| Previous Message | Tom Lane | 2023-01-02 18:05:22 | Re: Allow pageinspect's bt_page_stats function to return a set of rows instead of a single row |