diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2007-04-06 22:33:43 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2007-04-06 22:33:43 +0000 |
| commit | f02a82b6adad1af75499c4ac7221bbd94e3c4fbf (patch) | |
| tree | d15b0a2a52d95e046bb3945f4487982943ed211e /doc/src/sgml/ref/create_index.sgml | |
| parent | 146c83c045625d6f0072dd96045ebbc54582be05 (diff) | |
Make 'col IS NULL' clauses be indexable conditions.
Teodor Sigaev, with some kibitzing from Tom Lane.
Diffstat (limited to 'doc/src/sgml/ref/create_index.sgml')
| -rw-r--r-- | doc/src/sgml/ref/create_index.sgml | 8 |
1 files changed, 1 insertions, 7 deletions
diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index 69ba5d7a7a5..feebc4c164a 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.61 2007/04/03 22:38:35 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_index.sgml,v 1.62 2007/04/06 22:33:41 tgl Exp $ PostgreSQL documentation --> @@ -435,12 +435,6 @@ Indexes: </para> <para> - Indexes are not used for <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</> predicate. - </para> - - <para> Prior releases of <productname>PostgreSQL</productname> also had an R-tree index method. This method has been removed because it had no significant advantages over the GiST method. |