Home Explore Blog CI



postgresql

7th chunk of `doc/src/sgml/brin.sgml`
60145e5ac6e1b5a878905d4c359c660bb6eabc6408f1eec70000000100000fad
 <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>
     <entry><literal>= (macaddr,macaddr)</literal></entry>
    </row>
    <row><entry><literal>&lt; (macaddr,macaddr)</literal></entry></row>
    <row><entry><literal>&lt;= (macaddr,macaddr)</literal></entry></row>
    <row><entry><literal>&gt; (macaddr,macaddr)</literal></entry></row>
    <row><entry><literal>&gt;= (macaddr,macaddr)</literal></entry></row>

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

    <row>
     <entry valign="middle"><literal>macaddr8_bloom_ops</literal></entry>
     <entry><literal>= (macaddr8,macaddr8)</literal></entry>
    </row>

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

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

    <row>
     <entry valign="middle"><literal>name_bloom_ops</literal></entry>
     <entry><literal>= (name,name)</literal></entry>
    </row>

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

    <row>
     <entry valign="middle"><literal>numeric_bloom_ops</literal></entry>
     <entry><literal>= (numeric,numeric)</literal></entry>
    </row>

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

Title: BRIN Operator Classes for Various Data Types
Summary
The text continues listing built-in BRIN operator classes for different data types, including interval, macaddr, macaddr8, name, and numeric, each supporting various operators such as equality, less than, greater than, and containment, with some data types having bloom, minmax, and minmax multi operator classes.