File tree Expand file tree Collapse file tree 1 file changed +10
-1
lines changed
Expand file tree Collapse file tree 1 file changed +10
-1
lines changed Original file line number Diff line number Diff line change 1- <!-- $PostgreSQL: pgsql/doc/src/sgml/charset.sgml,v 2.70 2005/03/15 02:30:33 momjian Exp $ -->
1+ <!-- $PostgreSQL: pgsql/doc/src/sgml/charset.sgml,v 2.71 2005/03/17 00:22:24 neilc Exp $ -->
22
33<chapter id="charset">
44 <title>Localization</>
@@ -224,6 +224,15 @@ initdb --locale=sv_SE
224224 from being used by <literal>LIKE</>. For this reason use locales
225225 only if you actually need them.
226226 </para>
227+
228+ <para>
229+ As a workaround to allow <productname>PostgreSQL</> to use indexes
230+ with <literal>LIKE</> clauses under a non-C locale, several custom
231+ operator classes exist. These allow the creation of an index that
232+ performs a strict character-by-character comparison, ignoring
233+ locale comparison rules. Refer to <xref linkend="indexes-opclass">
234+ for more information.
235+ </para>
227236 </sect2>
228237
229238 <sect2>
You can’t perform that action at this time.
0 commit comments