diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2015-06-20 12:26:36 -0300 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2015-06-20 12:26:36 -0300 |
| commit | 1443a165db007462c5044ad8d03d919ac4323e6d (patch) | |
| tree | 11c68a17c85f474bf88624459f1f2a47e7a36004 | |
| parent | 3c400a3f2bf4bb93a60cefc09416d37fc3dab8ed (diff) | |
| download | postgresql-1443a165db007462c5044ad8d03d919ac4323e6d.tar.gz postgresql-1443a165db007462c5044ad8d03d919ac4323e6d.zip | |
Fix BRIN supported operators table
Some of the entries in the inclusion opclasses where missing operators,
and we had an entry for inet_inclusion_ops instead of
network_inclusion_ops. Sort the operators within each opclass by
strategy number, just to make it easier to spot mistakes.
Also sort the rows by data type name, rather than OID.
| -rw-r--r-- | doc/src/sgml/brin.sgml | 185 |
1 files changed, 93 insertions, 92 deletions
diff --git a/doc/src/sgml/brin.sgml b/doc/src/sgml/brin.sgml index 4d8fd20c1c4..e25f09c6800 100644 --- a/doc/src/sgml/brin.sgml +++ b/doc/src/sgml/brin.sgml @@ -89,8 +89,8 @@ </thead> <tbody> <row> - <entry><literal>bytea_minmax_ops</literal></entry> - <entry><type>bytea</type></entry> + <entry><literal>abstime_minmax_ops</literal></entry> + <entry><type>abstime</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -100,8 +100,8 @@ </entry> </row> <row> - <entry><literal>char_minmax_ops</literal></entry> - <entry><type>"char"</type></entry> + <entry><literal>int8_minmax_ops</literal></entry> + <entry><type>bigint</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -111,8 +111,8 @@ </entry> </row> <row> - <entry><literal>name_minmax_ops</literal></entry> - <entry><type>name</type></entry> + <entry><literal>bit_minmax_ops</literal></entry> + <entry><type>bit</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -122,8 +122,8 @@ </entry> </row> <row> - <entry><literal>int8_minmax_ops</literal></entry> - <entry><type>bigint</type></entry> + <entry><literal>varbit_minmax_ops</literal></entry> + <entry><type>bit varying</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -133,8 +133,26 @@ </entry> </row> <row> - <entry><literal>int2_minmax_ops</literal></entry> - <entry><type>smallint</type></entry> + <entry><literal>box_inclusion_ops</></entry> + <entry><type>box</type></entry> + <entry> + <literal><<</> + <literal>&<</> + <literal>&&</> + <literal>&></> + <literal>>></> + <literal>~=</> + <literal>@></> + <literal><@</> + <literal>&<|</> + <literal><<|</> + <literal>|>></literal> + <literal>|&></> + </entry> + </row> + <row> + <entry><literal>bytea_minmax_ops</literal></entry> + <entry><type>bytea</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -144,8 +162,8 @@ </entry> </row> <row> - <entry><literal>int4_minmax_ops</literal></entry> - <entry><type>integer</type></entry> + <entry><literal>bpchar_minmax_ops</literal></entry> + <entry><type>character</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -155,8 +173,8 @@ </entry> </row> <row> - <entry><literal>text_minmax_ops</literal></entry> - <entry><type>text</type></entry> + <entry><literal>char_minmax_ops</literal></entry> + <entry><type>"char"</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -166,8 +184,8 @@ </entry> </row> <row> - <entry><literal>oid_minmax_ops</literal></entry> - <entry><type>oid</type></entry> + <entry><literal>date_minmax_ops</literal></entry> + <entry><type>date</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -177,8 +195,8 @@ </entry> </row> <row> - <entry><literal>tid_minmax_ops</literal></entry> - <entry><type>tid</type></entry> + <entry><literal>float8_minmax_ops</literal></entry> + <entry><type>double precision</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -188,8 +206,8 @@ </entry> </row> <row> - <entry><literal>float4_minmax_ops</literal></entry> - <entry><type>real</type></entry> + <entry><literal>inet_minmax_ops</literal></entry> + <entry><type>inet</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -199,19 +217,20 @@ </entry> </row> <row> - <entry><literal>float8_minmax_ops</literal></entry> - <entry><type>double precision</type></entry> + <entry><literal>network_inclusion_ops</literal></entry> + <entry><type>inet</type></entry> <entry> - <literal><</literal> - <literal><=</literal> + <literal>&&</> + <literal>>>=</> + <literal><<=</literal> <literal>=</literal> - <literal>>=</literal> - <literal>></literal> + <literal>>></> + <literal><<</literal> </entry> </row> <row> - <entry><literal>abstime_minmax_ops</literal></entry> - <entry><type>abstime</type></entry> + <entry><literal>int4_minmax_ops</literal></entry> + <entry><type>integer</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -221,8 +240,8 @@ </entry> </row> <row> - <entry><literal>reltime_minmax_ops</literal></entry> - <entry><type>reltime</type></entry> + <entry><literal>interval_minmax_ops</literal></entry> + <entry><type>interval</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -243,8 +262,8 @@ </entry> </row> <row> - <entry><literal>inet_minmax_ops</literal></entry> - <entry><type>inet</type></entry> + <entry><literal>name_minmax_ops</literal></entry> + <entry><type>name</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -254,20 +273,19 @@ </entry> </row> <row> - <entry><literal>inet_inclusion_ops</literal></entry> - <entry><type>inet</type></entry> + <entry><literal>numeric_minmax_ops</literal></entry> + <entry><type>numeric</type></entry> <entry> - <literal>&&</> - <literal>>></> - <literal>>>=</> - <literal><<</literal> - <literal><<=</literal> + <literal><</literal> + <literal><=</literal> <literal>=</literal> + <literal>>=</literal> + <literal>></literal> </entry> </row> <row> - <entry><literal>bpchar_minmax_ops</literal></entry> - <entry><type>character</type></entry> + <entry><literal>pg_lsn_minmax_ops</literal></entry> + <entry><type>pg_lsn</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -277,8 +295,8 @@ </entry> </row> <row> - <entry><literal>date_minmax_ops</literal></entry> - <entry><type>date</type></entry> + <entry><literal>oid_minmax_ops</literal></entry> + <entry><type>oid</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -288,19 +306,28 @@ </entry> </row> <row> - <entry><literal>time_minmax_ops</literal></entry> - <entry><type>time without time zone</type></entry> + <entry><literal>range_inclusion_ops</></entry> + <entry><type>any range type</type></entry> <entry> + <literal><<</> + <literal>&<</> + <literal>&&</> + <literal>&></> + <literal>>></> + <literal>@></> + <literal><@</> + <literal>-|-</> + <literal>=</> <literal><</literal> <literal><=</literal> <literal>=</literal> - <literal>>=</literal> <literal>></literal> + <literal>>=</literal> </entry> </row> <row> - <entry><literal>timestamp_minmax_ops</literal></entry> - <entry><type>timestamp without time zone</type></entry> + <entry><literal>float4_minmax_ops</literal></entry> + <entry><type>real</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -310,8 +337,8 @@ </entry> </row> <row> - <entry><literal>timestamptz_minmax_ops</literal></entry> - <entry><type>timestamp with time zone</type></entry> + <entry><literal>reltime_minmax_ops</literal></entry> + <entry><type>reltime</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -321,8 +348,8 @@ </entry> </row> <row> - <entry><literal>interval_minmax_ops</literal></entry> - <entry><type>interval</type></entry> + <entry><literal>int2_minmax_ops</literal></entry> + <entry><type>smallint</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -332,8 +359,8 @@ </entry> </row> <row> - <entry><literal>timetz_minmax_ops</literal></entry> - <entry><type>time with time zone</type></entry> + <entry><literal>text_minmax_ops</literal></entry> + <entry><type>text</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -343,8 +370,8 @@ </entry> </row> <row> - <entry><literal>bit_minmax_ops</literal></entry> - <entry><type>bit</type></entry> + <entry><literal>tid_minmax_ops</literal></entry> + <entry><type>tid</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -354,8 +381,8 @@ </entry> </row> <row> - <entry><literal>varbit_minmax_ops</literal></entry> - <entry><type>bit varying</type></entry> + <entry><literal>timestamp_minmax_ops</literal></entry> + <entry><type>timestamp without time zone</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -365,8 +392,8 @@ </entry> </row> <row> - <entry><literal>numeric_minmax_ops</literal></entry> - <entry><type>numeric</type></entry> + <entry><literal>timestamptz_minmax_ops</literal></entry> + <entry><type>timestamp with time zone</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -376,8 +403,8 @@ </entry> </row> <row> - <entry><literal>uuid_minmax_ops</literal></entry> - <entry><type>uuid</type></entry> + <entry><literal>time_minmax_ops</literal></entry> + <entry><type>time without time zone</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -387,17 +414,9 @@ </entry> </row> <row> - <entry><literal>range_inclusion_ops</></entry> - <entry><type>any range type</type></entry> + <entry><literal>timetz_minmax_ops</literal></entry> + <entry><type>time with time zone</type></entry> <entry> - <literal>&&</> - <literal>&></> - <literal>&<</> - <literal>>></> - <literal><<</> - <literal><@</> - <literal>=</> - <literal>@></> <literal><</literal> <literal><=</literal> <literal>=</literal> @@ -406,8 +425,8 @@ </entry> </row> <row> - <entry><literal>pg_lsn_minmax_ops</literal></entry> - <entry><type>pg_lsn</type></entry> + <entry><literal>uuid_minmax_ops</literal></entry> + <entry><type>uuid</type></entry> <entry> <literal><</literal> <literal><=</literal> @@ -416,24 +435,6 @@ <literal>></literal> </entry> </row> - <row> - <entry><literal>box_inclusion_ops</></entry> - <entry><type>box</type></entry> - <entry> - <literal>&&</> - <literal>&></> - <literal>&<</> - <literal>>></> - <literal><<</> - <literal><@</> - <literal>~=</> - <literal>@></> - <literal>&>|</> - <literal>|&<</> - <literal>>>|</> - <literal>|<<</literal> - </entry> - </row> </tbody> </tgroup> </table> |