From d2158b02813bb44116988eeb10d9a32565b58c1c Mon Sep 17 00:00:00 2001 From: Teodor Sigaev Date: Wed, 24 May 2006 11:01:39 +0000 Subject: * Add support NULL to GiST. * some refactoring and simplify code int gistutil.c and gist.c * now in some cases it can be called used-defined picksplit method for non-first column in index, but here is a place to do more. * small fix of docs related to support NULL. --- doc/src/sgml/indexam.sgml | 5 ++--- doc/src/sgml/indices.sgml | 16 ++++++++-------- 2 files changed, 10 insertions(+), 11 deletions(-) (limited to 'doc/src') diff --git a/doc/src/sgml/indexam.sgml b/doc/src/sgml/indexam.sgml index 61956cdfcf5..70fba4ecc0a 100644 --- a/doc/src/sgml/indexam.sgml +++ b/doc/src/sgml/indexam.sgml @@ -1,4 +1,4 @@ - + Index Access Method Interface Definition @@ -126,8 +126,7 @@ used to scan for rows with a = 4, which is wrong if the index omits rows where b is null. It is, however, OK to omit rows where the first indexed column is null. - (GiST currently does so.) Thus, - amindexnulls should be set true only if the + Thus, amindexnulls should be set true only if the index access method indexes all rows, including arbitrary combinations of null values. diff --git a/doc/src/sgml/indices.sgml b/doc/src/sgml/indices.sgml index 9bb19c2cee0..10669c01557 100644 --- a/doc/src/sgml/indices.sgml +++ b/doc/src/sgml/indices.sgml @@ -1,4 +1,4 @@ - + Indexes @@ -290,13 +290,13 @@ CREATE INDEX test2_mm_idx ON test2 (major, minor); - A multicolumn GiST index can only be used when there is a query condition - on its leading column. Conditions on additional columns restrict the - entries returned by the index, but the condition on the first column is the - most important one for determining how much of the index needs to be - scanned. A GiST index will be relatively ineffective if its first column - has only a few distinct values, even if there are many distinct values in - additional columns. + A multicolumn GiST index can be used with query conditions that + involve any subset of the index's columns. Conditions on additional + columns restrict the entries returned by the index, but the condition on + the first column is the most important one for determining how much of + the index needs to be scanned. A GiST index will be relatively + ineffective if its first column has only a few distinct values, even if + there are many distinct values in additional columns. -- cgit v1.2.3