Re: Strange behaviors with ranges

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

-- 
Adrian Klaver
adrian.klaver@aklaver.com