Re: Inconsistent results from seqscan and gist indexscan

2021-11-26 Thread Tom Lane
Richard Guo writes: > On Fri, Nov 26, 2021 at 5:23 PM Julien Rouhaud wrote: >> On Fri, Nov 26, 2021 at 2:10 PM Richard Guo >> wrote: >>> Seems point_inside() does not handle NaN properly. >> This is unfortunately a known issue, which was reported twice ([1] and >> [2]) already. There's a patch

Re: Inconsistent results from seqscan and gist indexscan

2021-11-26 Thread Richard Guo
On Fri, Nov 26, 2021 at 5:23 PM Julien Rouhaud wrote: > Hi, > > On Fri, Nov 26, 2021 at 2:10 PM Richard Guo > wrote: > > > > Seems point_inside() does not handle NaN properly. > > This is unfortunately a known issue, which was reported twice ([1] and > [2]) already. There's a patch proposed for

Re: Inconsistent results from seqscan and gist indexscan

2021-11-26 Thread Julien Rouhaud
Hi, On Fri, Nov 26, 2021 at 2:10 PM Richard Guo wrote: > > Seems point_inside() does not handle NaN properly. This is unfortunately a known issue, which was reported twice ([1] and [2]) already. There's a patch proposed for it: https://commitfest.postgresql.org/32/2710/ (adding Horiguchi-san in