Re: record identical operator

Поиск
Список
Период
Сортировка
От Hannu Krosing
Тема Re: record identical operator
Дата
Msg-id 52381C0C.6080404@2ndQuadrant.com
обсуждение исходный текст
Ответ на Re: record identical operator  (Kevin Grittner <kgrittn@ymail.com>)
Ответы Re: record identical operator  (Kevin Grittner <kgrittn@ymail.com>)
Список pgsql-hackers
On 09/16/2013 04:01 PM, Kevin Grittner wrote:
> Hannu Krosing <hannu@2ndQuadrant.com> wrote:
>
>> Lots of people were bitten when (undocumented) hash
>> functions were changed thus breaking hash-based partitioning.
> Nobody can be affected by the new operators in this patch unless
> they choose to use them to compare two records.  They don't work
> for any other type and they don't come into play unless you
> specifically request them.
>
Maybe the binary equality operator should be named ====
for "really deeply equal"

to distinguish it from === which would be merely NOT DISTINCT FROM

we could even go one step further and define ===== to mean "the same".

?

This could fit better in conceptual sequence of operator 'strength'

-- 
Hannu Krosing
PostgreSQL Consultant
Performance, Scalability and High Availability
2ndQuadrant Nordic OÜ




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

Предыдущее
От: Rushabh Lathia
Дата:
Сообщение: Re: insert throw error when year field len > 4 for timestamptz datatype
Следующее
От: "Etsuro Fujita"
Дата:
Сообщение: Typo fix in spgtextproc.c