Re: Exclude constraint on ranges : commutative containment : allowonly complete containment

On 1/30/20 9:03 AM, Achilleas Mantzios wrote:

>>
>> Um, that makes my head hurt:) Questions:
>>
>> 1) Are the basic complete budgets and the sub-budgets and super 
>> budgets existing in the same table?
>>
>> 2) Depending on answer to 1, to prevent overlap could you not use a 
>> form of the example here?:
>>
>> https://www.postgresql.org/docs/12/rangetypes.html#RANGETYPES-CONSTRAINT
>>
>> CREATE TABLE reservation (
>>     during tsrange,
>>     EXCLUDE USING GIST (during WITH &&)
>> );
>>
> same table.
> overlap is allowed but only when it is complete containment, which is 
> the whole point of this thread.
> 

I finally got it. Unfortunately that does not mean I have solution.


-- 
Adrian Klaver
adrian.klaver@aklaver.com