Re: record identical operator

Поиск
Список
Период
Сортировка
От Vik Fearing
Тема Re: record identical operator
Дата
Msg-id 523A373C.5080702@dalibo.com
обсуждение исходный текст
Ответ на Re: record identical operator  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Ответы Re: record identical operator  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 09/19/2013 12:55 AM, Dimitri Fontaine wrote:
>> We have, as a community, gone to a fair amount of trouble  to make
>> > the concept of equality pluggable and allow multiple types of
>> > equality per type.  To me it seems the perfect tool to solve this
>> > problem.  Why the fuss?
> Because I don't understand why you need another equality than the
> default btree one, certainly.

Basically because 'word'::citext and 'Word'::citext are the same to your
brain but not to your eyeballs.

Unique indexes, for example, only need to please your brain.  Matviews
need to please your eyeballs.

-- 
Vik




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

Предыдущее
От: Dimitri Fontaine
Дата:
Сообщение: Re: record identical operator
Следующее
От: David Johnston
Дата:
Сообщение: Re: Not In Foreign Key Constraint