Re: Wrong results from in_range() tests with infinite offset

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Wrong results from in_range() tests with infinite offset
Date: 2020-07-17 00:59:57
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com> writes:
> On Thu, 16 Jul 2020, 22:50 Tom Lane, <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Actually, after staring at those results awhile longer, I decided
>> they were wrong. The results shown here seem actually sane ---
>> for instance, -Infinity shouldn't "infinitely precede" itself,
>> I think. (Maybe if you got solipsistic enough you could argue
>> that that is valid, but it seems pretty bogus.)

> Hmm, that code looks a bit fishy to me, but I really need to think about it
> some more. I'll take another look tomorrow, and maybe it'll become clearer.

It's certainly verbose, so I'd like to find a more concise way to
write the logic. But the v2 results seem right.

regards, tom lane

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2020-07-17 01:16:47 Re: Encoding of src/timezone/tznames/Europe.txt
Previous Message Michael Paquier 2020-07-17 00:15:10 Re: TAP tests and symlinks on Windows