|
1 | | -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/indices.sgml,v 1.25 2001/11/08 23:34:33 petere Exp $ --> |
| 1 | +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/indices.sgml,v 1.26 2001/11/18 00:59:00 tgl Exp $ --> |
2 | 2 |
|
3 | 3 | <chapter id="indexes"> |
4 | 4 | <title id="indexes-title">Indexes</title> |
@@ -105,7 +105,7 @@ CREATE INDEX test1_id_index ON test1 (id); |
105 | 105 |
|
106 | 106 | <para> |
107 | 107 | <productname>Postgres</productname> provides several index types: |
108 | | - B-tree, R-tree, and Hash. Each index type is more appropriate for |
| 108 | + B-tree, R-tree,GiST,and Hash. Each index type is more appropriate for |
109 | 109 | a particular query type because of the algorithm it uses. |
110 | 110 | <indexterm> |
111 | 111 | <primary>indexes</primary> |
@@ -235,7 +235,7 @@ CREATE INDEX test2_mm_idx ON test2 (major, minor); |
235 | 235 | </para> |
236 | 236 |
|
237 | 237 | <para> |
238 | | - Currently, only the B-treeimplementation supports multicolumn |
| 238 | + Currently, only the B-treeand GiST implementations support multicolumn |
239 | 239 | indexes. Up to 16 columns may be specified. (This limit can be |
240 | 240 | altered when building <productname>Postgres</productname>; see the |
241 | 241 | file <filename>pg_config.h</filename>.) |
@@ -291,7 +291,7 @@ SELECT name FROM test2 WHERE major = <replaceable>constant</replaceable> OR mino |
291 | 291 | <synopsis> |
292 | 292 | CREATE UNIQUE INDEX <replaceable>name</replaceable> ON <replaceable>table</replaceable> (<replaceable>column</replaceable> <optional>, ...</optional>); |
293 | 293 | </synopsis> |
294 | | -Only B-tree indexes can be declared unique. |
| 294 | +Currently, only B-tree indexes can be declared unique. |
295 | 295 | </para> |
296 | 296 |
|
297 | 297 | <para> |
|