Re: Custom collations, collation modifiers (eg case-insensitive)

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