Home • Explore • Blog • CI
☰



postgresql
8th chunk of `doc/src/sgml/brin.sgml`
45e2da51e8ad47644442334b9af2a18d8aee94708e0bc5b70000000100000fa2
 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; (numeric,numeric)</literal></entry></row>
    <row><entry><literal>&gt;= (numeric,numeric)</literal></entry></row>

    <row>
     <entry valign="middle" morerows="4"><literal>numeric_minmax_multi_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; (numeric,numeric)</literal></entry></row>
    <row><entry><literal>&gt;= (numeric,numeric)</literal></entry></row>

    <row>
     <entry valign="middle"><literal>oid_bloom_ops</literal></entry>
     <entry><literal>= (oid,oid)</literal></entry>
    </row>

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

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

    <row>
     <entry valign="middle"><literal>pg_lsn_bloom_ops</literal></entry>
     <entry><literal>= (pg_lsn,pg_lsn)</literal></entry>
    </row>

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

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

    <row>
     <entry valign="middle" morerows="13"><literal>range_inclusion_ops</literal></entry>
     <entry><literal>= (anyrange,anyrange)</literal></entry>
    </row>
    <row><entry><literal>&lt; (anyrange,anyrange)</literal></entry></row>
    <row><entry><literal>&lt;= (anyrange,anyrange)</literal></entry></row>
    <row><entry><literal>&gt;=
Title: BRIN Operator Classes for Various Data Types
Summary
The text lists built-in BRIN operator classes for different data types, including name, numeric, oid, pg_lsn, and range types, 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, providing a range of comparison operations for each data type.