NaN behavior

Поиск
Список
Период
Сортировка
От Neil Conway
Тема NaN behavior
Дата
Msg-id 1168567452.5462.29.camel@localhost.localdomain
обсуждение исходный текст
Ответы Re: NaN behavior  (Neil Conway <neilc@samurai.com>)
Список pgsql-hackers
postgres=# select 'NaN'::numeric = 'NaN'::numeric,                 'NaN'::float8 = 'NaN'::float8;?column? | ?column? 
----------+----------t        | t
(1 row)

This behavior is inconsistent with most people's notion of "NaN" -- in
particular, it is inconsistent with IEEE754. I can understand why
Postgres behaves this way, and we probably can't easily change it (if we
want to continue indexing NaN values, that is), but I think it should at
least be discussed in the documentation.

Comments? I'll write up a doc patch, barring any objections.

-Neil




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: [PERFORM] unusual performance for vac following 8.2upgrade
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: PANIC: block 463 unfound during REDO after out of