Feedback-ID: i76984098:Fastmail
Message-ID: <cbf220ba-469d-4dc2-9231-14457c4e9ad1@aklaver.com>
Date: Tue, 27 Aug 2024 11:27:42 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Strange behaviors with ranges
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Jean-Christophe BOGGIO <postgresql@thefreecat.org>,
 =?UTF-8?Q?Torsten_F=C3=B6rtsch?= <tfoertsch123@gmail.com>
Cc: pgsql-general@lists.postgresql.org
References: <77691006-45f1-4ef9-bc1b-2eecd44f7d0d@thefreecat.org>
 <572cc9d2-a981-4f0e-802a-69515dac1722@aklaver.com>
 <CAKkG4_=nj6sdNg2VGfsbWsRbdgTGAoOWLusZTcVdCeNpnt1-DA@mail.gmail.com>
 <4da6abeb-6c35-4eaf-8d77-420ed467651e@thefreecat.org>
 <41e2ee2e-3f27-4f2c-86b0-8252411fdc75@aklaver.com>
Content-Language: en-US
In-Reply-To: <41e2ee2e-3f27-4f2c-86b0-8252411fdc75@aklaver.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/cbf220ba-469d-4dc2-9231-14457c4e9ad1%40aklaver.com>
Precedence: bulk


On 8/27/24 11:16 AM, Adrian Klaver wrote:
> 
> 
> On 8/27/24 11:13 AM, Jean-Christophe BOGGIO wrote:
>> Le 27/08/2024 à 19:51, Torsten Förtsch a écrit :
>>> I guess this query comes back non-empty:
>>>
>>> SELECT * FROM paliers JOIN tmp_limitcontrats USING(idcontrat) WHERE 
>>> qtep1 >= qtep2
>>
>> Yes, it is empty if I keep tmp_limitcontrats to idcontrat=1003
>>
>> Otherwise, you are right, there are irregular data but not that I'm 
>> concerned with in that particular case.
>>
> 
> ?:
> SELECT numrange( qtep1+1   , qtep2,  '[]') AS rangep FROM paliers JOIN 
> tmp_limitcontrats USING(idcontrat) where qtep1+1 < qtep2
> 

Actually that should be:

qtep1+1 <= qtep2

-- 
Adrian Klaver
adrian.klaver@aklaver.com