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

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Dean Rasheed <dean.a.rasheed@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2020-07-17T00:59:57Z
Lists: pgsql-hackers
Dean Rasheed <dean.a.rasheed@gmail.com> writes:
> On Thu, 16 Jul 2020, 22:50 Tom Lane, <tgl@sss.pgh.pa.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



Commits

  1. Fix some corner cases for window ranges with infinite offsets.