From 157003abde8e7792406e247b6892fa7647a034f2 Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Wed, 18 Jan 2006 22:26:01 +0000
Subject: [PATCH] Clarify use of btree indexes for ILIKE and ~*.

---
 doc/src/sgml/indices.sgml | 22 +++++++++++++---------
 1 file changed, 13 insertions(+), 9 deletions(-)

diff --git a/doc/src/sgml/indices.sgml b/doc/src/sgml/indices.sgml
index 2040c98084..915fb5fb3b 100644
--- a/doc/src/sgml/indices.sgml
+++ b/doc/src/sgml/indices.sgml
@@ -141,17 +141,21 @@ CREATE INDEX test1_id_index ON test1 (id);
 
   <para>
    The optimizer can also use a B-tree index for queries involving the
-   pattern matching operators <literal>LIKE</>,
-   <literal>ILIKE</literal>, <literal>~</literal>, and
-   <literal>~*</literal>, <emphasis>if</emphasis> the pattern is a constant
-   and is anchored to the beginning of the string &mdash; for example,
-   <literal>col LIKE 'foo%'</literal> or <literal>col ~ '^foo'</literal>,
-   but not <literal>col LIKE '%bar'</literal>.  However, if your server does
-   not use the C locale you will need to create the index with a
-   special operator class to support indexing of pattern-matching queries.
-   See <xref linkend="indexes-opclass"> below.
+   pattern matching operators <literal>LIKE</> and <literal>~</literal>
+   <emphasis>if</emphasis> the pattern is a constant and is anchored to
+   the beginning of the string &mdash; for example, <literal>col LIKE
+   'foo%'</literal> or <literal>col ~ '^foo'</literal>, but not
+   <literal>col LIKE '%bar'</literal>. However, if your server does not
+   use the C locale you will need to create the index with a special
+   operator class to support indexing of pattern-matching queries. See
+   <xref linkend="indexes-opclass"> below. It is also possible to use
+   B-tree indexes for <literal>ILIKE</literal> and
+   <literal>~*</literal>, but only if the pattern starts with
+   non-alphabetic characters, i.e. characters that are not affected by
+   upper/lower case conversion.
   </para>
 
+
   <para>
    <indexterm>
     <primary>index</primary>
-- 
2.39.5