Skip to content

Commit 957f51e

Browse files
author
Neil Conway
committed
Add a reference to the documentation on alternate index operator classes in
the locale docs. Patch from Chris KL, editorialization by Neil Conway.
1 parent d663d3b commit 957f51e

File tree

1 file changed

+10
-1
lines changed

1 file changed

+10
-1
lines changed

doc/src/sgml/charset.sgml

Lines changed: 10 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
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>

0 commit comments

Comments
 (0)