Re: [PATCH] Support empty ranges with bounds information

From: Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com>
To: Pantelis Theodosiou <ypercube(at)gmail(dot)com>
Cc: Joel Jacobson <joel(at)compiler(dot)org>, Postgres hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Isaac Morland <isaac(dot)morland(at)gmail(dot)com>
Subject: Re: [PATCH] Support empty ranges with bounds information
Date: 2021-03-02 16:57:52
Message-ID: D3713AB8-4186-4CAA-8AC0-81D6C7AA1B69@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> On Mar 2, 2021, at 8:51 AM, Pantelis Theodosiou <ypercube(at)gmail(dot)com> wrote:
>
>
>
> On Tue, Mar 2, 2021 at 3:28 PM Mark Dilger <mark(dot)dilger(at)enterprisedb(dot)com> wrote:
>
>
> > On Mar 2, 2021, at 5:20 AM, Joel Jacobson <joel(at)compiler(dot)org> wrote:
> >
> > it's currently not possible to create an empty range with bounds information.
> >
> > This patch tries to improve the situation by keeping the bounds information,
> > and allow accessing it via lower() and upper().
> >
> > No other semantics have been changed.
> > All tests passes without any changes.
>
> I recall this issue of empty ranges not keeping any bounds information being discussed back when range types were developed, and the design choice was intentional. Searching the archives for that discussion, I don't find anything, probably because I'm not searching for the right keywords. Anybody have a link to that discussion?
>
> —
> Mark Dilger
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
>
> Marc, perhaps you were referring to this discussion?
> https://www.postgresql.org/message-id/4D5534D0020000250003A87E@gw.wicourts.gov

Yes, I believe so. Thank you for the link.


Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jacob Champion 2021-03-02 17:10:13 Re: Table AM modifications to accept column projection lists
Previous Message Vik Fearing 2021-03-02 16:51:52 Re: GROUP BY DISTINCT