Re: "two time periods with only an endpoint in common do not overlap" ??? - Mailing list pgsql-general

From David G. Johnston
Subject Re: "two time periods with only an endpoint in common do not overlap" ???
Date
Msg-id CAKFQuwbqA_UUmhSgfyuO46G=dYhzh+Th4gWirjHb1A=m6DLC9Q@mail.gmail.com
Whole thread Raw
In response to Re: "two time periods with only an endpoint in common do not overlap" ???  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: "two time periods with only an endpoint in common do not overlap" ???
List pgsql-general
On Friday, October 15, 2021, Ron <ronljohnsonjr@gmail.com> wrote:

Prima facie, if you were told "numbers in the range 0-10", would you really think, "ah, they really mean 0 through 9"?


I would indeed default to both endpoints of the range being inclusive.  I also begin counting at one, not zero.  I’ve long gotten past being surprised when computer science and my defaults don’t agree.  Choices are made and documented and that works for me.

As for this, documentation I never really gave the wording a second thought before, though I can definitely understand the complaint and like the somewhat wordier, but less linguistically challenging, phrasing the OP suggested (Boundary point, especially by itself, is not an improvement).

David J.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: "two time periods with only an endpoint in common do not overlap" ???
Next
From: Gavin Flower
Date:
Subject: Re: "two time periods with only an endpoint in common do not overlap" ???