Re: Issue with point_ops and NaN - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Issue with point_ops and NaN
Date
Msg-id 2840025.1617116552@sss.pgh.pa.us
Whole thread Raw
In response to Re: Issue with point_ops and NaN  (Julien Rouhaud <rjuju123@gmail.com>)
List pgsql-hackers
Julien Rouhaud <rjuju123@gmail.com> writes:
> On Tue, Mar 30, 2021 at 02:47:05PM +0200, Laurenz Albe wrote:
>> I'd say that this is certainly wrong:
>> SELECT point('NaN','NaN') <@ polygon('(0,0),(1,0),(1,1),(0,0)');
>> 
>> ?column? 
>> ----------
>>  t
>>  (1 row)

> Yeah that's what I think too, but I wanted to have confirmation.

Agreed --- one could make an argument for either 'false' or NULL
result, but surely not 'true'.

I wonder if Horiguchi-san's patch [1] improves this case.

            regards, tom lane

[1] https://commitfest.postgresql.org/32/2710/



pgsql-hackers by date:

Previous
From: Greg Rychlewski
Date:
Subject: DROP INDEX docs - explicit lock naming
Next
From: Alvaro Herrera
Date:
Subject: Re: Refactor SSL test framework to support multiple TLS libraries