From ae7363999ff36a6857b968ffee8487519273709b Mon Sep 17 00:00:00 2001 From: Heikki Linnakangas Date: Mon, 22 Apr 2013 21:51:14 +0300 Subject: [PATCH] Mention in docs that you can create SP-GiST indexes on range types. This is new in 9.3devel. --- doc/src/sgml/rangetypes.sgml | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/doc/src/sgml/rangetypes.sgml b/doc/src/sgml/rangetypes.sgml index 15cbef6e69..8dabc833e9 100644 --- a/doc/src/sgml/rangetypes.sgml +++ b/doc/src/sgml/rangetypes.sgml @@ -371,9 +371,9 @@ SELECT '[1.234, 5.678]'::floatrange; - In addition, any range type that is meant to be used with GiST indexes + In addition, any range type that is meant to be used with GiST or SP-GiST indexes should define a subtype difference, or subtype_diff, function. - (A GiST index will still work without subtype_diff, but it is + (the index will still work without subtype_diff, but it is likely to be considerably less efficient than if a difference function is provided.) The subtype difference function takes two input values of the subtype, and returns their difference (i.e., X minus @@ -394,7 +394,7 @@ SELECT '[1.234, 5.678]'::floatrange; - + Indexing @@ -403,12 +403,12 @@ SELECT '[1.234, 5.678]'::floatrange; - GiST indexes can be created for table columns of range types. - For instance: + GiST and SP-GiST indexes can be created for table columns of range types. + For instance, to create a GiST index: CREATE INDEX reservation_idx ON reservation USING gist (during); - A GiST index can accelerate queries involving these range operators: + A GiST or SP-GiST index can accelerate queries involving these range operators: =, &&, <@, -- 2.40.0