Home • Explore • Blog • CI
☰



postgresql
4th chunk of `doc/src/sgml/brin.sgml`
e043e01a86495b1942150f5b293f2a7bbb7dea71682a15ff0000000100000fc7
 valign="middle" morerows="4"><literal>bytea_minmax_ops</literal></entry>
     <entry><literal>= (bytea,bytea)</literal></entry>
    </row>
    <row><entry><literal>&lt; (bytea,bytea)</literal></entry></row>
    <row><entry><literal>&lt;= (bytea,bytea)</literal></entry></row>
    <row><entry><literal>&gt; (bytea,bytea)</literal></entry></row>
    <row><entry><literal>&gt;= (bytea,bytea)</literal></entry></row>

    <row>
     <entry valign="middle"><literal>char_bloom_ops</literal></entry>
     <entry><literal>= ("char","char")</literal></entry>
    </row>

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

    <row>
     <entry valign="middle"><literal>date_bloom_ops</literal></entry>
     <entry><literal>= (date,date)</literal></entry>
    </row>

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

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

    <row>
     <entry valign="middle"><literal>float4_bloom_ops</literal></entry>
     <entry><literal>= (float4,float4)</literal></entry>
    </row>

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

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

    <row>
     <entry valign="middle"><literal>float8_bloom_ops</literal></entry>
     <entry><literal>= (float8,float8)</literal></entry>
    </row>

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

    <row>
     <entry valign="middle" morerows="4"><literal>float8_minmax_multi_ops</literal></entry>
     <entry><literal>= (float8,float8)</literal></entry>
    </row>
    <row><entry><literal>&lt; (float8,float8)</literal></entry></row>
    <row><entry><literal>&lt;= (float8,float8)</literal></entry></row>
    <row><entry><literal>&gt; (float8,float8)</literal></entry></row>
Title: Built-in BRIN Operator Classes for Various Data Types
Summary
The provided text lists built-in BRIN operator classes for different data types, including bytea, char, date, float4, and float8, each supporting various operators such as equality, less than, greater than, and containment, with some data types also having multi-minmax operator classes.