Home • Explore • Blog • CI
☰



postgresql
10th chunk of `doc/src/sgml/brin.sgml`
a739869a05806487a0ac4057a52ff61f4dc2a3f2381d85430000000100000fa0
 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>

    <row>
     <entry valign="middle" morerows="4"><literal>timestamp_minmax_multi_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>

    <row>
     <entry valign="middle"><literal>timestamptz_bloom_ops</literal></entry>
     <entry><literal>= (timestamptz,timestamptz)</literal></entry>
    </row>

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

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

    <row>
     <entry valign="middle"><literal>time_bloom_ops</literal></entry>
     <entry><literal>= (time,time)</literal></entry>
    </row>

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

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

    <row>
     <entry valign="middle"><literal>timetz_bloom_ops</literal></entry>
     <entry><literal>= (timetz,timetz)</literal></entry>
    </row>

    <row>
     <entry valign="middle" morerows="4"><literal>timetz_minmax_ops</literal></entry>
     <entry><literal>= (timetz,timetz)</literal></entry>
    </row>
Title: BRIN Operator Classes for Temporal and Time-Based Data Types
Summary
The text lists various BRIN operator classes for temporal and time-based data types, including tid, timestamp, timestamptz, time, and timetz, each supporting operators such as equality, less than, greater than, and range-specific operators, with some data types having bloom, minmax, and minmax multi operator classes, providing a range of comparison operations for each data type.