This just adds a link to the pattern_ops operator class section from the
part of the locale docs that mentions that indexes don't work for LIKE
under a non-C locale.

(untested)

Chris

Index: doc/src/sgml/charset.sgml
================================================== =================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/charset.sgml,v
retrieving revision 2.69
diff -c -r2.69 charset.sgml
*** doc/src/sgml/charset.sgml 14 Mar 2005 18:31:19 -0000 2.69
--- doc/src/sgml/charset.sgml 15 Mar 2005 01:55:10 -0000
***************
*** 224,229 ****
--- 224,236 ----
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 index
+ <literal>LIKE</> under a non-C locale, several custom <link linkend="indexes-opclass">operator classes</link>
+ exist that allow a strict character-by-character comparison, ignoring
+ locale comparison rules.
+ </para>
</sect2>

<sect2>


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Christopher Kings-Lynne wrote:
> This just adds a link to the pattern_ops operator class section from the
> part of the locale docs that mentions that indexes don't work for LIKE
> under a non-C locale.

Patch applied, with some changes. We can't assume that the reader can
follow hyperlinks, since they won't be available in every format (e.g.
printouts of a PDF). So the text should be written with an explicit
section reference as well as a link.

-Neil

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend