Re: Infinite Interval - Mailing list pgsql-hackers

From Vik Fearing
Subject Re: Infinite Interval
Date
Msg-id 0c1a4a55-bc13-59d1-1e2d-8d74870eec7a@postgresfriends.org
Whole thread Raw
In response to Re: Infinite Interval  (jian he <jian.universality@gmail.com>)
List pgsql-hackers
On 12/31/22 06:09, jian he wrote:
> 
> Since in float8 you can use '+inf', '+infinity', So should we also make
> interval '+infinity' valid?

Yes.

> Also in timestamp. '+infinity'::timestamp is invalid, should we make it
> valid.

Yes, we should.  I wrote a trivial patch for this a while ago but it 
appears I never posted it.  I will post that in a new thread so as not 
to confuse the bots.
-- 
Vik Fearing




pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Fixing a couple of buglets in how VACUUM sets visibility map bits
Next
From: Vik Fearing
Date:
Subject: +infinity for dates and timestamps