diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2001-11-18 00:59:00 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2001-11-18 00:59:00 +0000 |
| commit | 5906d7e09601d874086ca0ac04e999b765ab2fbf (patch) | |
| tree | 11c1bcf60f20969031221900ffdcf6d3cb2b91bb | |
| parent | 0729c4a61fbd1d897dd200bc774796cd3c2fd401 (diff) | |
| download | postgresql-5906d7e09601d874086ca0ac04e999b765ab2fbf.tar.gz postgresql-5906d7e09601d874086ca0ac04e999b765ab2fbf.zip | |
Fix obsolete claim that only btree indexes support multiple columns;
GiST does now, too. (Someone needs to write a description of GiST
to add to this chapter. I don't know enough about it ...)
| -rw-r--r-- | doc/src/sgml/indices.sgml | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/doc/src/sgml/indices.sgml b/doc/src/sgml/indices.sgml index 34d8df3cd17..26ffcfc0c22 100644 --- a/doc/src/sgml/indices.sgml +++ b/doc/src/sgml/indices.sgml @@ -1,4 +1,4 @@ -<!-- $Header: /cvsroot/pgsql/doc/src/sgml/indices.sgml,v 1.25 2001/11/08 23:34:33 petere Exp $ --> +<!-- $Header: /cvsroot/pgsql/doc/src/sgml/indices.sgml,v 1.26 2001/11/18 00:59:00 tgl Exp $ --> <chapter id="indexes"> <title id="indexes-title">Indexes</title> @@ -105,7 +105,7 @@ CREATE INDEX test1_id_index ON test1 (id); <para> <productname>Postgres</productname> provides several index types: - B-tree, R-tree, and Hash. Each index type is more appropriate for + B-tree, R-tree, GiST, and Hash. Each index type is more appropriate for a particular query type because of the algorithm it uses. <indexterm> <primary>indexes</primary> @@ -235,7 +235,7 @@ CREATE INDEX test2_mm_idx ON test2 (major, minor); </para> <para> - Currently, only the B-tree implementation supports multicolumn + Currently, only the B-tree and GiST implementations support multicolumn indexes. Up to 16 columns may be specified. (This limit can be altered when building <productname>Postgres</productname>; see the file <filename>pg_config.h</filename>.) @@ -291,7 +291,7 @@ SELECT name FROM test2 WHERE major = <replaceable>constant</replaceable> OR mino <synopsis> CREATE UNIQUE INDEX <replaceable>name</replaceable> ON <replaceable>table</replaceable> (<replaceable>column</replaceable> <optional>, ...</optional>); </synopsis> - Only B-tree indexes can be declared unique. + Currently, only B-tree indexes can be declared unique. </para> <para> |