Craig Ringer wrote: > (I intensely dislike the idea of ignoring accents, but it's something > some people appear to need/want, and is supported by other vendors).
FWIW at least in spanish, users always want to search for entries ignoring accents. Nowadays I think most turn to unaccent(), but before that was written people resorted to calling transform() on both the stored data and the user-entered query, so that all pertinent matches would be found. People would even create indexes on the unaccented data to speed this up. It's an important feature, not a corner case by any means. Not sure about other languages. For instance perhaps in French they would be interested in ignoring some accents but not others. -- Á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