Re: Is upper_inc ever true for dateranges?

2020-07-28 Thread Ken Tanzer
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

Re: Is upper_inc ever true for dateranges?

2020-07-28 Thread David G. Johnston
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

Is upper_inc ever true for dateranges?

2020-07-28 Thread Ken Tanzer
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