| From: | jian he <jian(dot)universality(at)gmail(dot)com> |
|---|---|
| To: | Paul A Jungwirth <pj(at)illuminatedcomputing(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: domain for WITHOUT OVERLAPS |
| Date: | 2025-12-11 04:23:07 |
| Message-ID: | CACJufxEABtUZf=M9h3XpvjiWKFNDxObPpe6Ly9_dd-k3_xJJ+w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Dec 4, 2025 at 2:39 AM Paul A Jungwirth
<pj(at)illuminatedcomputing(dot)com> wrote:
>
> I think there are these cases to consider:
>
> - WITHOUT OVERLAPS on a rangetype whose subtype has a domain
> - WITHOUT OVERLAPS on a rangetype with a domain on itself
> - WITHOUT OVERLAPS on a multirangetype whose subtype has a domain
> - WITHOUT OVERLAPS on a multirangetype whose rangetype has a domain
> - WITHOUT OVERLAPS on a multirangetype with a domain on itself
>
hi.
please check the attached polished test. (no C code change).
I think the test I am missing is
> - WITHOUT OVERLAPS on a multirangetype whose rangetype has a domain
because it expects CREATE DOMAIN also to create a multirange type for rangetype.
but currently we didn't do it.
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-domain-for-WITHOUT-OVERLAPS.patch | text/x-patch | 16.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ashutosh Bapat | 2025-12-11 04:59:42 | Re: Report bytes and transactions actually sent downtream |
| Previous Message | Chao Li | 2025-12-11 04:06:57 | Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) |