public inbox for [email protected]
help / color / mirror / Atom feedRe: Strange behaviors with ranges
3+ messages / 2 participants
[nested] [flat]
* Re: Strange behaviors with ranges
@ 2024-08-27 18:13 Jean-Christophe BOGGIO <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Jean-Christophe BOGGIO @ 2024-08-27 18:13 UTC (permalink / raw)
To: Torsten Förtsch <[email protected]>; Adrian Klaver <[email protected]>; +Cc: [email protected]
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Strange behaviors with ranges
@ 2024-08-27 18:16 Adrian Klaver <[email protected]>
parent: Jean-Christophe BOGGIO <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Adrian Klaver @ 2024-08-27 18:16 UTC (permalink / raw)
To: Jean-Christophe BOGGIO <[email protected]>; Torsten Förtsch <[email protected]>; +Cc: [email protected]
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
[email protected]
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Strange behaviors with ranges
@ 2024-08-27 18:27 Adrian Klaver <[email protected]>
parent: Adrian Klaver <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: Adrian Klaver @ 2024-08-27 18:27 UTC (permalink / raw)
To: Jean-Christophe BOGGIO <[email protected]>; Torsten Förtsch <[email protected]>; +Cc: [email protected]
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
[email protected]
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-08-27 18:27 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-08-27 18:13 Re: Strange behaviors with ranges Jean-Christophe BOGGIO <[email protected]>
2024-08-27 18:16 ` Adrian Klaver <[email protected]>
2024-08-27 18:27 ` Adrian Klaver <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox