Search Postgresql Archives

Re: Is upper_inc ever true for dateranges?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Jul 28, 2020 at 2:24 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Tue, Jul 28, 2020 at 2:19 PM Ken Tanzer <ken.tanzer@xxxxxxxxx> 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 canonicalized while ranges over non-discrete types (i.e., float) cannot.


Oh that makes perfect sense.  Thank you!

Ken

 
David J.




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

learn more about AGENCY or
follow the discussion.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux