Re: Exclude constraint on ranges : commutative containment : allow only complete containment

From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Exclude constraint on ranges : commutative containment : allow only complete containment
Date: 2020-01-30 07:33:31
Message-ID: 4c091fe8-8cc5-c0f9-8a17-cc50e74683a7@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 29/1/20 8:43 μ.μ., Michael Lewis wrote:

> If the new value does not overlap with any existing, allow. If it does
> overlap, then it must be fully contained by the existing element, or
> the existing element must be fully contained by it. Else, reject. Is
> that right?

Exactly.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2020-01-30 11:46:31 Re: Exclude constraint on ranges : commutative containment : allow only complete containment
Previous Message Tom Lane 2020-01-29 23:54:12 Re: Performance Issue after upgrade from 9 to 11