Subject: Re: Strange behaviors with ranges

From: Jean-Christophe BOGGIO <[email-masked]>
Date: Tue, 27 Aug 2024 20:13:46 +0200

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.

---

From: Adrian Klaver <[email-masked]>
Date: Tue, 27 Aug 2024 11:16:57 -0700

> 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
[email-masked]

---

From: Adrian Klaver <[email-masked]>
Date: Tue, 27 Aug 2024 11:27:42 -0700

> tmp_limitcontrats USING(idcontrat) where qtep1+1 < qtep2

Actually that should be:

qtep1+1 <= qtep2