Re: record identical operator - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: record identical operator
Date
Msg-id 20130920185017.GC4832@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: record identical operator  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
List pgsql-hackers
Dimitri Fontaine escribió:

> My understanding is that if you choose citext then you don't care at all
> about the case, so that the two relations actually yield the same
> results for the right definition of "same" here: the citext one.

For the record, I don't think citext means that the user doesn't care"
about the case; it only means they want the comparisons to be
case-insensitive, but case should nonetheless be preserved.  That is,
"case-insensitive, case-preserving".  A parallel is MS-DOS file name
semantics.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: UTF8 national character data type support WIP patch and list of open issues.
Next
From: Robert Haas
Date:
Subject: Re: [RFC] Extend namespace of valid guc names