Re: Infinite Interval - Mailing list pgsql-hackers

From jian he
Subject Re: Infinite Interval
Date
Msg-id CACJufxFbyVsdGzDEnoTKbfYa=rasCDa8NP5xb-MMd9o4=8V7Hw@mail.gmail.com
Whole thread Raw
In response to Re: Infinite Interval  (Joseph Koshakow <koshy44@gmail.com>)
Responses Re: Infinite Interval  (Vik Fearing <vik@postgresfriends.org>)
Re: Infinite Interval  (Joseph Koshakow <koshy44@gmail.com>)
List 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 recommend David Deutsch's <<The Beginning of Infinity>>

  Jian


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgres_fdw: using TABLESAMPLE to collect remote sample
Next
From: Noah Misch
Date:
Subject: Re: Is RecoveryConflictInterrupt() entirely safe in a signal handler?