Re: Inconsistent results from seqscan and gist indexscan

Hi,

On Fri, Nov 26, 2021 at 2:10 PM Richard Guo <guofenglinux@gmail.com> 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
Cc).

[1]: https://www.postgresql.org/message-id/flat/CAGf+fX70rWFOk5cd00uMfa__0yP+vtQg5ck7c2Onb-Yczp0URA@mail.gmail.com
[2]: https://www.postgresql.org/message-id/20210330095751.x5hnqbqcxilzwjlm%40nol