Re: Building infrastructure for B-Tree deduplication that recognizes when opclass equality is also equivalence

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: Building infrastructure for B-Tree deduplication that recognizes when opclass equality is also equivalence
Дата
Msg-id 87wodpkod2.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: Building infrastructure for B-Tree deduplication that recognizes when opclass equality is also equivalence  (Antonin Houska <ah@cybertec.at>)
Список pgsql-hackers
>>>>> "Antonin" == Antonin Houska <ah@cybertec.at> writes:

 >> It is set to false for numeric and float4, float8.

 Antonin> Are you sure about these?

numeric values can compare equal but have different display scales (see
hash_numeric).

float4 and float8 both have representations for -0, which compares equal
to 0. (numeric technically has a representation for -0 too, but I
believe the current code carefully avoids ever generating it.)

-- 
Andrew (irc:RhodiumToad)



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

Предыдущее
От: Antonin Houska
Дата:
Сообщение: Re: Building infrastructure for B-Tree deduplication that recognizes when opclass equality is also equivalence
Следующее
От: Andrey Borodin
Дата:
Сообщение: Re: Optimize partial TOAST decompression