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
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 |