Home • Explore • Blog • CI
☰



postgresql
9th chunk of `doc/src/sgml/brin.sgml`
597333eda375a64a8b4b7e04e133c21bf4a9a9a5caf992a60000000100000fab
 <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;= (anyrange,anyrange)</literal></entry></row>
    <row><entry><literal>&gt; (anyrange,anyrange)</literal></entry></row>
    <row><entry><literal>&amp;&amp; (anyrange,anyrange)</literal></entry></row>
    <row><entry><literal>@&gt; (anyrange,anyelement)</literal></entry></row>
    <row><entry><literal>@&gt; (anyrange,anyrange)</literal></entry></row>
    <row><entry><literal>&lt;@ (anyrange,anyrange)</literal></entry></row>
    <row><entry><literal>&lt;&lt; (anyrange,anyrange)</literal></entry></row>
    <row><entry><literal>&gt;&gt; (anyrange,anyrange)</literal></entry></row>
    <row><entry><literal>&amp;&lt; (anyrange,anyrange)</literal></entry></row>
    <row><entry><literal>&amp;&gt; (anyrange,anyrange)</literal></entry></row>
    <row><entry><literal>-|- (anyrange,anyrange)</literal></entry></row>

    <row>
     <entry valign="middle"><literal>text_bloom_ops</literal></entry>
     <entry><literal>= (text,text)</literal></entry>
    </row>

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

    <row>
     <entry valign="middle"><literal>tid_bloom_ops</literal></entry>
     <entry><literal>= (tid,tid)</literal></entry>
    </row>

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

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

    <row>
     <entry valign="middle"><literal>timestamp_bloom_ops</literal></entry>
     <entry><literal>= (timestamp,timestamp)</literal></entry>
    </row>

    <row>
     <entry valign="middle" morerows="4"><literal>timestamp_minmax_ops</literal></entry>
     <entry><literal>= (timestamp,timestamp)</literal></entry>
    </row>
    <row><entry><literal>&lt; (timestamp,timestamp)</literal></entry></row>
    <row><entry><literal>&lt;= (timestamp,timestamp)</literal></entry></row>
    <row><entry><literal>&gt; (timestamp,timestamp)</literal></entry></row>
    <row><entry><literal>&gt;= (timestamp,timestamp)</literal></entry></row>
Title: BRIN Operator Classes for Various Data Types
Summary
The text continues to list built-in BRIN operator classes for different data types, including pg_lsn, range, text, tid, and timestamp, each supporting various operators such as equality, less than, greater than, and range-specific operators, providing a range of comparison operations for each data type, with some data types having bloom, minmax, and minmax multi operator classes.