From: | Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Is upper_inc ever true for dateranges? |
Date: | 2020-07-28 21:26:22 |
Message-ID: | CAD3a31VOmB15sgvDQ2f2A9t5zs55riowu9iokzkajQvxMFHXpQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Jul 28, 2020 at 2:24 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
> On Tue, Jul 28, 2020 at 2:19 PM Ken Tanzer <ken(dot)tanzer(at)gmail(dot)com> 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
*http://agency-software.org/ <http://agency-software.org/>*
*https://demo.agency-software.org/client
<https://demo.agency-software.org/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801
Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2020-07-28 21:28:06 | Re: bad JIT decision |
Previous Message | David G. Johnston | 2020-07-28 21:23:55 | Re: Is upper_inc ever true for dateranges? |