Re: Exclude constraint on ranges : commutative containment : allowonly complete containment - Mailing list pgsql-general

From Achilleas Mantzios
Subject Re: Exclude constraint on ranges : commutative containment : allowonly complete containment
Date
Msg-id 4c091fe8-8cc5-c0f9-8a17-cc50e74683a7@matrix.gatewaynet.com
Whole thread Raw
In response to Re: Exclude constraint on ranges : commutative containment : allowonly complete containment  (Michael Lewis <mlewis@entrata.com>)
List 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.




pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Performance Issue after upgrade from 9 to 11
Next
From: Achilleas Mantzios
Date:
Subject: Re: Exclude constraint on ranges : commutative containment : allowonly complete containment