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

<p dir="ltr">This feature is interesting for Czech language too. Lot of applications allows accent free searching due
possibleissues in original data or some client limits - missing Czech keyboard and similar<div class="gmail_quote">Dne
21.1.201417:17 "Alvaro Herrera" <<a href="mailto:alvherre@2ndquadrant.com">alvherre@2ndquadrant.com</a>>
napsal(a):<brtype="attribution" /><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc
solid;padding-left:1ex">Craig Ringer wrote:<br /><br /> > (I intensely dislike the idea of ignoring accents, but
it'ssomething<br /> > some people appear to need/want, and is supported by other vendors).<br /><br /> FWIW at least
inspanish, users always want to search for entries<br /> ignoring accents.  Nowadays I think most turn to unaccent(),
butbefore<br /> that was written people resorted to calling transform() on both the<br /> stored data and the
user-enteredquery, so that all pertinent matches<br /> would be found.  People would even create indexes on the
unaccenteddata<br /> to speed this up.  It's an important feature, not a corner case by any<br /> means.<br /><br />
Notsure about other languages.  For instance perhaps in French they<br /> would be interested in ignoring some accents
butnot others.<br /><br /> --<br /> Álvaro Herrera                <a href="http://www.2ndQuadrant.com/"
target="_blank">http://www.2ndQuadrant.com/</a><br/> PostgreSQL Development, 24x7 Support, Training & Services<br
/><br/><br /> --<br /> Sent via pgsql-hackers mailing list (<a
href="mailto:pgsql-hackers@postgresql.org">pgsql-hackers@postgresql.org</a>)<br/> To make changes to your
subscription:<br/><a href="http://www.postgresql.org/mailpref/pgsql-hackers"
target="_blank">http://www.postgresql.org/mailpref/pgsql-hackers</a><br/></blockquote></div>