Re: record identical operator - Mailing list pgsql-hackers

From Vik Fearing
Subject Re: record identical operator
Date
Msg-id 523A373C.5080702@dalibo.com
Whole thread Raw
In response to Re: record identical operator  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Responses Re: record identical operator
List 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 by date:

Previous
From: Dimitri Fontaine
Date:
Subject: Re: record identical operator
Next
From: David Johnston
Date:
Subject: Re: Not In Foreign Key Constraint