On Tue, Jul 28, 2020 at 2:24 PM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Tue, Jul 28, 2020 at 2:19 PM Ken Tanzer wrote:
>
>> 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
On Tue, Jul 28, 2020 at 2:19 PM Ken Tanzer wrote:
> 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?
>
Ranges over discrete types are always canoni
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 a