From 5906d7e09601d874086ca0ac04e999b765ab2fbf Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sun, 18 Nov 2001 00:59:00 +0000 Subject: [PATCH] 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 ...) --- doc/src/sgml/indices.sgml | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/doc/src/sgml/indices.sgml b/doc/src/sgml/indices.sgml index 34d8df3cd1..26ffcfc0c2 100644 --- a/doc/src/sgml/indices.sgml +++ b/doc/src/sgml/indices.sgml @@ -1,4 +1,4 @@ - + Indexes @@ -105,7 +105,7 @@ CREATE INDEX test1_id_index ON test1 (id); Postgres 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. indexes @@ -235,7 +235,7 @@ CREATE INDEX test2_mm_idx ON test2 (major, minor); - 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 Postgres; see the file pg_config.h.) @@ -291,7 +291,7 @@ SELECT name FROM test2 WHERE major = constant OR mino CREATE UNIQUE INDEX name ON table (column , ...); - Only B-tree indexes can be declared unique. + Currently, only B-tree indexes can be declared unique. -- 2.40.0