Is upper_inc ever true for dateranges? - Mailing list pgsql-general

From Ken Tanzer
Subject Is upper_inc ever true for dateranges?
Date
Msg-id CAD3a31X-c9HpHr0B7-NWkAco-XWh_pHL6D-ixMuMgv=Xsnbz=Q@mail.gmail.com
Whole thread Raw
Responses Re: Is upper_inc ever true for dateranges?
List pgsql-general
Hi.  Regardless of how I specify a daterange, it is converted to inclusive lower bound, exclusive upper bound ('[)'):

SELECT daterange('2019-01-01','2020-01-01','(]') AS range;
          range          
-------------------------
 [2019-01-02,2020-01-02)

So here's my question.  Will the upper_inc function always return false for a non-null daterange?  And if so, what's the point of the function?  And/or is it different for other kinds of ranges?

lower_inc at least seems to return true if lower bound is not null, but false if it is null.


WITH r AS (SELECT daterange('2020-01-01','2020-01-31','(]') AS range) SELECT range,upper_inc(range),lower_inc(range) FROM r;

          range          | upper_inc | lower_inc
-------------------------+-----------+-----------
 [2020-01-02,2020-02-01) | f         | t

     range     | upper_inc | lower_inc
---------------+-----------+-----------
 [2020-01-02,) | f         | t

     range     | upper_inc | lower_inc
---------------+-----------+-----------
 (,2020-01-02) | f         | f

Thanks in advance!

Ken



--
AGENCY Software  
A Free Software data system
By and for non-profits
(253) 245-3801

learn more about AGENCY or
follow the discussion.

pgsql-general by date:

Previous
From: Andres Freund
Date:
Subject: Re: bad JIT decision
Next
From: "David G. Johnston"
Date:
Subject: Re: Is upper_inc ever true for dateranges?