Re: Issue with point_ops and NaN

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Issue with point_ops and NaN
Дата
Msg-id 2840025.1617116552@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Issue with point_ops and NaN  (Julien Rouhaud <rjuju123@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Greg Rychlewski
Дата:
Сообщение: DROP INDEX docs - explicit lock naming
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Refactor SSL test framework to support multiple TLS libraries