Home Explore Blog CI



postgresql

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

    <row>
     <entry valign="middle" morerows="5"><literal>inet_inclusion_ops</literal></entry>
     <entry><literal>&lt;&lt; (inet,inet)</literal></entry>
    </row>
    <row><entry><literal>&lt;&lt;= (inet,inet)</literal></entry></row>
    <row><entry><literal>&gt;&gt; (inet,inet)</literal></entry></row>
    <row><entry><literal>&gt;&gt;= (inet,inet)</literal></entry></row>
    <row><entry><literal>= (inet,inet)</literal></entry></row>
    <row><entry><literal>&amp;&amp; (inet,inet)</literal></entry></row>

    <row>
     <entry valign="middle"><literal>inet_bloom_ops</literal></entry>
     <entry><literal>= (inet,inet)</literal></entry>
    </row>

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

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

    <row>
     <entry valign="middle"><literal>int2_bloom_ops</literal></entry>
     <entry><literal>= (int2,int2)</literal></entry>
    </row>

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

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

    <row>
     <entry valign="middle"><literal>int4_bloom_ops</literal></entry>
     <entry><literal>= (int4,int4)</literal></entry>
    </row>

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

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 float8, inet, int2, and int4, each supporting various operators such as equality, less than, greater than, and containment, with some data types also having multi-minmax and bloom operator classes.