aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorNeil Conway <neilc@samurai.com>2005-03-17 00:22:24 +0000
committerNeil Conway <neilc@samurai.com>2005-03-17 00:22:24 +0000
commit957f51ea6ba96709b87dbed00ee54df4a9a8a6c9 (patch)
treeb206be3021dd935fb04f56587ec954ca0d1bdb7c /doc/src
parentd663d3ba3afc8c4b80d3b122a3ea125d18c3ab82 (diff)
downloadpostgresql-957f51ea6ba96709b87dbed00ee54df4a9a8a6c9.tar.gz
postgresql-957f51ea6ba96709b87dbed00ee54df4a9a8a6c9.zip
Add a reference to the documentation on alternate index operator classes in
the locale docs. Patch from Chris KL, editorialization by Neil Conway.
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/charset.sgml11
1 files changed, 10 insertions, 1 deletions
diff --git a/doc/src/sgml/charset.sgml b/doc/src/sgml/charset.sgml
index cf07adba569..dc8a429244d 100644
--- a/doc/src/sgml/charset.sgml
+++ b/doc/src/sgml/charset.sgml
@@ -1,4 +1,4 @@
-<!-- $PostgreSQL: pgsql/doc/src/sgml/charset.sgml,v 2.70 2005/03/15 02:30:33 momjian Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/charset.sgml,v 2.71 2005/03/17 00:22:24 neilc Exp $ -->
<chapter id="charset">
<title>Localization</>
@@ -224,6 +224,15 @@ initdb --locale=sv_SE
from being used by <literal>LIKE</>. For this reason use locales
only if you actually need them.
</para>
+
+ <para>
+ As a workaround to allow <productname>PostgreSQL</> to use indexes
+ with <literal>LIKE</> clauses under a non-C locale, several custom
+ operator classes exist. These allow the creation of an index that
+ performs a strict character-by-character comparison, ignoring
+ locale comparison rules. Refer to <xref linkend="indexes-opclass">
+ for more information.
+ </para>
</sect2>
<sect2>