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

This feature is interesting for Czech language too. Lot of applications
allows accent free searching due possible issues in original data or some
client limits - missing Czech keyboard and similar
Dne 21.1.2014 17:17 "Alvaro Herrera" <alvherre(at)2ndquadrant(dot)com> napsal(a):

> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>