[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Is upper_inc ever true for dateranges?
From:       Ken Tanzer <ken.tanzer () gmail ! com>
Date:       2020-07-28 21:26:22
Message-ID: CAD3a31VOmB15sgvDQ2f2A9t5zs55riowu9iokzkajQvxMFHXpQ () mail ! gmail ! com
[Download RAW message or body]

On Tue, Jul 28, 2020 at 2:24 PM David G. Johnston <
david.g.johnston@gmail.com> wrote:

> On Tue, Jul 28, 2020 at 2:19 PM Ken Tanzer <ken.tanzer@gmail.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.tanzer@agency-software.org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request@lists.sourceforge.net?body=subscribe> to
learn more about AGENCY or
follow the discussion.

[Attachment #3 (text/html)]

<div dir="ltr"><div dir="ltr">On Tue, Jul 28, 2020 at 2:24 PM David G. Johnston \
&lt;<a href="mailto:david.g.johnston@gmail.com">david.g.johnston@gmail.com</a>&gt; \
wrote:<br></div><div class="gmail_quote"><blockquote class="gmail_quote" \
style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr"><div \
style="font-family:arial,helvetica,sans-serif"><span \
style="font-family:Arial,Helvetica,sans-serif">On Tue, Jul 28, 2020 at 2:19 PM Ken \
Tanzer &lt;<a href="mailto:ken.tanzer@gmail.com" \
target="_blank">ken.tanzer@gmail.com</a>&gt; wrote:</span><br></div></div><div \
class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div \
dir="ltr"><div><div>So here&#39;s my question.   Will the upper_inc function always \
return false for a non-null daterange?   And if so, what&#39;s the point of the \
function?   And/or is it different for other kinds of \
ranges?<br></div></div></div></blockquote><div><br></div><div><div \
style="font-family:arial,helvetica,sans-serif">Ranges over discrete types are always \
canonicalized while ranges over non-discrete types (i.e., float) cannot.</div><div \
style="font-family:arial,helvetica,sans-serif"><br></div></div></div></div></blockquote><div><br></div><div>Oh \
that makes perfect sense.   Thank \
you!</div><div><br></div><div>Ken</div><div><br></div><div>  </div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div class="gmail_quote"><div><div \
style="font-family:arial,helvetica,sans-serif"></div><div \
style="font-family:arial,helvetica,sans-serif">David J.</div><div \
style="font-family:arial,helvetica,sans-serif"><br></div><br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"> </blockquote></div></div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" \
class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><img \
src="https://agency-software.org/agency_logo_medium.png"><div><font size="4">AGENCY \
Software   </font><br><div>A Free Software data system</div><div>By and for \
non-profits</div><div><i><a href="http://agency-software.org/" \
target="_blank">http://agency-software.org/</a></i></div><div><i><a \
href="https://demo.agency-software.org/client" \
target="_blank">https://demo.agency-software.org/client</a></i><br></div><div><a \
href="mailto:ken.tanzer@agency-software.org" \
target="_blank">ken.tanzer@agency-software.org</a></div><div>(253) \
245-3801</div><div><br></div></div><div><a \
href="mailto:agency-general-request@lists.sourceforge.net?body=subscribe" \
target="_blank">Subscribe to the mailing list</a>  to</div><div>learn more about \
AGENCY or</div><div>follow the \
discussion.</div></div></div></div></div></div></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]