From b0b7be61337fc64147f2ad0af5bf2c0e6b8a709f Mon Sep 17 00:00:00 2001 From: Alvaro Herrera Date: Fri, 15 May 2015 18:05:22 -0300 Subject: Add BRIN infrastructure for "inclusion" opclasses This lets BRIN be used with R-Tree-like indexing strategies. Also provided are operator classes for range types, box and inet/cidr. The infrastructure provided here should be sufficient to create operator classes for similar datatypes; for instance, opclasses for PostGIS geometries should be doable, though we didn't try to implement one. (A box/point opclass was also submitted, but we ripped it out before commit because the handling of floating point comparisons in existing code is inconsistent and would generate corrupt indexes.) Author: Emre Hasegeli. Cosmetic changes by me Review: Andreas Karlsson --- doc/src/sgml/brin.sgml | 53 +++++++++++++++++++++++++++++++++++++++++++++++++- 1 file changed, 52 insertions(+), 1 deletion(-) (limited to 'doc/src') diff --git a/doc/src/sgml/brin.sgml b/doc/src/sgml/brin.sgml index 92dac7c60b5..4d8fd20c1c4 100644 --- a/doc/src/sgml/brin.sgml +++ b/doc/src/sgml/brin.sgml @@ -72,7 +72,9 @@ The minmax operator classes store the minimum and the maximum values appearing - in the indexed column within the range. + in the indexed column within the range. The inclusion + operator classes store a value which includes the values in the indexed + column within the range. @@ -251,6 +253,18 @@ > + + inet_inclusion_ops + inet + + && + >> + >>= + << + <<= + = + + bpchar_minmax_ops character @@ -372,6 +386,25 @@ > + + range_inclusion_ops + any range type + + && + &> + &< + >> + << + <@ + = + @> + < + <= + = + >= + > + + pg_lsn_minmax_ops pg_lsn @@ -383,6 +416,24 @@ > + + box_inclusion_ops + box + + && + &> + &< + >> + << + <@ + ~= + @> + &>| + |&< + >>| + |<< + +
-- cgit v1.2.3