Re: Strange behaviors with ranges - Mailing list pgsql-general

From Jean-Christophe BOGGIO
Subject Re: Strange behaviors with ranges
Date
Msg-id 4da6abeb-6c35-4eaf-8d77-420ed467651e@thefreecat.org
Whole thread Raw
In response to Re: Strange behaviors with ranges  (Torsten Förtsch <tfoertsch123@gmail.com>)
Responses Re: Strange behaviors with ranges
List pgsql-general
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.


pgsql-general by date:

Previous
From: Paul Jungwirth
Date:
Subject: Re: Strange behaviors with ranges
Next
From: Adrian Klaver
Date:
Subject: Re: Strange behaviors with ranges