Request a Demo
Home   >   mailing lists

Re: domain for WITHOUT OVERLAPS - Mailing list pgsql-hackers

From jian he
Subject Re: domain for WITHOUT OVERLAPS
Date
Msg-id CACJufxEABtUZf=M9h3XpvjiWKFNDxObPpe6Ly9_dd-k3_xJJ+w@mail.gmail.com
Whole thread Raw
In response to Re: domain for WITHOUT OVERLAPS  (Paul A Jungwirth <pj@illuminatedcomputing.com>)
List pgsql-hackers
Tree view 
On Thu, Dec 4, 2025 at 2:39 AM Paul A Jungwirth
<pj@illuminatedcomputing.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.


--
jian
https://www.enterprisedb.com
Attachment

pgsql-hackers by date:

Previous
From: Chao Li
Date:
Subject: Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)
Next
From: Ashutosh Bapat
Date:
Subject: Re: Report bytes and transactions actually sent downtream