Home • Explore • Blog • CI
☰



postgresql
6th chunk of `doc/src/sgml/brin.sgml`
4ec8ae7057bbe291df45b927b5962c35d0f6fb60a352721c0000000100000fa0
 (int2,int2)</literal></entry></row>
    <row><entry><literal>&lt;= (int2,int2)</literal></entry></row>
    <row><entry><literal>&gt;= (int2,int2)</literal></entry></row>

    <row>
     <entry valign="middle" morerows="4"><literal>int2_minmax_multi_ops</literal></entry>
     <entry><literal>= (int2,int2)</literal></entry>
    </row>
    <row><entry><literal>&lt; (int2,int2)</literal></entry></row>
    <row><entry><literal>&gt; (int2,int2)</literal></entry></row>
    <row><entry><literal>&lt;= (int2,int2)</literal></entry></row>
    <row><entry><literal>&gt;= (int2,int2)</literal></entry></row>

    <row>
     <entry valign="middle"><literal>int4_bloom_ops</literal></entry>
     <entry><literal>= (int4,int4)</literal></entry>
    </row>

    <row>
     <entry valign="middle" morerows="4"><literal>int4_minmax_ops</literal></entry>
     <entry><literal>= (int4,int4)</literal></entry>
    </row>
    <row><entry><literal>&lt; (int4,int4)</literal></entry></row>
    <row><entry><literal>&gt; (int4,int4)</literal></entry></row>
    <row><entry><literal>&lt;= (int4,int4)</literal></entry></row>
    <row><entry><literal>&gt;= (int4,int4)</literal></entry></row>

    <row>
     <entry valign="middle" morerows="4"><literal>int4_minmax_multi_ops</literal></entry>
     <entry><literal>= (int4,int4)</literal></entry>
    </row>
    <row><entry><literal>&lt; (int4,int4)</literal></entry></row>
    <row><entry><literal>&gt; (int4,int4)</literal></entry></row>
    <row><entry><literal>&lt;= (int4,int4)</literal></entry></row>
    <row><entry><literal>&gt;= (int4,int4)</literal></entry></row>

    <row>
     <entry valign="middle"><literal>int8_bloom_ops</literal></entry>
     <entry><literal>= (bigint,bigint)</literal></entry>
    </row>

    <row>
     <entry valign="middle" morerows="4"><literal>int8_minmax_ops</literal></entry>
     <entry><literal>= (bigint,bigint)</literal></entry>
    </row>
    <row><entry><literal>&lt; (bigint,bigint)</literal></entry></row>
    <row><entry><literal>&gt; (bigint,bigint)</literal></entry></row>
    <row><entry><literal>&lt;= (bigint,bigint)</literal></entry></row>
    <row><entry><literal>&gt;= (bigint,bigint)</literal></entry></row>

    <row>
     <entry valign="middle" morerows="4"><literal>int8_minmax_multi_ops</literal></entry>
     <entry><literal>= (bigint,bigint)</literal></entry>
    </row>
    <row><entry><literal>&lt; (bigint,bigint)</literal></entry></row>
    <row><entry><literal>&gt; (bigint,bigint)</literal></entry></row>
    <row><entry><literal>&lt;= (bigint,bigint)</literal></entry></row>
    <row><entry><literal>&gt;= (bigint,bigint)</literal></entry></row>

    <row>
     <entry valign="middle"><literal>interval_bloom_ops</literal></entry>
     <entry><literal>= (interval,interval)</literal></entry>
    </row>

    <row>
     <entry valign="middle" morerows="4"><literal>interval_minmax_ops</literal></entry>
     <entry><literal>= (interval,interval)</literal></entry>
    </row>
    <row><entry><literal>&lt; (interval,interval)</literal></entry></row>
    <row><entry><literal>&lt;= (interval,interval)</literal></entry></row>
    <row><entry><literal>&gt; (interval,interval)</literal></entry></row>
    <row><entry><literal>&gt;= (interval,interval)</literal></entry></row>

    <row>
     <entry valign="middle" morerows="4"><literal>interval_minmax_multi_ops</literal></entry>
     <entry><literal>= (interval,interval)</literal></entry>
    </row>
    <row><entry><literal>&lt; (interval,interval)</literal></entry></row>
    <row><entry><literal>&lt;= (interval,interval)</literal></entry></row>
    <row><entry><literal>&gt; (interval,interval)</literal></entry></row>
    <row><entry><literal>&gt;= (interval,interval)</literal></entry></row>

    <row>
     <entry valign="middle"><literal>macaddr_bloom_ops</literal></entry>
     <entry><literal>= (macaddr,macaddr)</literal></entry>
    </row>

    <row>
     <entry valign="middle" morerows="4"><literal>macaddr_minmax_ops</literal></entry>
Title: BRIN Operator Classes for Data Types
Summary
The text lists various built-in BRIN operator classes for different data types, including int2, int4, int8, interval, and macaddr, each supporting operators such as equality, less than, greater than, and containment, with some data types having bloom, minmax, and minmax multi operator classes.