|
1 | 1 | <!-- |
2 | | -$PostgreSQL: pgsql/doc/src/sgml/ref/create_index.sgml,v 1.45 2004/04/2001:00:26 momjian Exp $ |
| 2 | +$PostgreSQL: pgsql/doc/src/sgml/ref/create_index.sgml,v 1.46 2004/04/2004:25:47 momjian Exp $ |
3 | 3 | PostgreSQL documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -77,11 +77,9 @@ CREATE [ UNIQUE ] INDEX <replaceable class="parameter">name</replaceable> ON <re |
77 | 77 | </para> |
78 | 78 |
|
79 | 79 | <para> |
80 | | - <literal>NULL</> values are not indexed by default. The best way |
81 | | - to index <literal>NULL</> values is to create a partial index using |
82 | | - an <literal>IS NULL</> comparison. <literal>IS NULL</> is more |
83 | | - of a function call than a value comparison, and this is why a partial |
84 | | - index works. |
| 80 | + Indexes can not be used with <literal>IS NULL</> clauses by default. |
| 81 | + The best way to use indexes in such cases is to create a partial index |
| 82 | + using an <literal>IS NULL</> comparison. |
85 | 83 | </para> |
86 | 84 |
|
87 | 85 | <para> |
|