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