From bb18b4739001cfbfb38584f467d53d97666cc114 Mon Sep 17 00:00:00 2001
From: Bruce Momjian
Date: Tue, 20 Apr 2004 04:25:47 +0000
Subject: Document partial indexes for IS NULL lookups.

---
 doc/src/sgml/ref/create_index.sgml | 10 ++++------
 1 file changed, 4 insertions(+), 6 deletions(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml
index 34e12c6a5d2..43583df54d5 100644
--- a/doc/src/sgml/ref/create_index.sgml
+++ b/doc/src/sgml/ref/create_index.sgml
@@ -1,5 +1,5 @@
 <!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/create_index.sgml,v 1.45 2004/04/20 01:00:26 momjian Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/create_index.sgml,v 1.46 2004/04/20 04:25:47 momjian Exp $
 PostgreSQL documentation
 -->
 
@@ -77,11 +77,9 @@ CREATE [ UNIQUE ] INDEX <replaceable class="parameter">name</replaceable> ON <re
   </para>
 
   <para>
-   <literal>NULL</> values are not indexed by default.  The best way
-   to index <literal>NULL</> values is to create a partial index using
-   an <literal>IS NULL</> comparison.  <literal>IS NULL</> is more
-   of a function call than a value comparison, and this is why a partial
-   index works.
+   Indexes can not be used with <literal>IS NULL</> clauses by default.
+   The best way to use indexes in such cases is to create a partial index 
+   using an <literal>IS NULL</> comparison.
   </para>
 
   <para>
-- 
cgit v1.2.3