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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers