Home • Explore • Blog • CI
☰



postgresql
2nd chunk of `doc/src/sgml/gist.sgml`
009d5119ad69ee067d220f5869048a16615495fdf4e230000000000100000fa0

     <row><entry><literal>&lt;@ (box, box)</literal></entry></row>
     <row><entry><literal>&amp;&lt;| (box, box)</literal></entry></row>
     <row><entry><literal>&lt;&lt;| (box, box)</literal></entry></row>
     <row><entry><literal>|&gt;&gt; (box, box)</literal></entry></row>
     <row><entry><literal>|&amp;&gt; (box, box)</literal></entry></row>

     <row>
      <entry valign="middle" morerows="11"><literal>circle_ops</literal></entry>
      <entry><literal>&lt;&lt; (circle, circle)</literal></entry>
      <entry valign="middle" morerows="11"><literal>&lt;-&gt; (circle, point)</literal></entry>
     </row>
     <row><entry><literal>&amp;&lt; (circle, circle)</literal></entry></row>
     <row><entry><literal>&amp;&gt; (circle, circle)</literal></entry></row>
     <row><entry><literal>&gt;&gt; (circle, circle)</literal></entry></row>
     <row><entry><literal>&lt;@ (circle, circle)</literal></entry></row>
     <row><entry><literal>@&gt; (circle, circle)</literal></entry></row>
     <row><entry><literal>~= (circle, circle)</literal></entry></row>
     <row><entry><literal>&amp;&amp; (circle, circle)</literal></entry></row>
     <row><entry><literal>|&gt;&gt; (circle, circle)</literal></entry></row>
     <row><entry><literal>&lt;&lt;| (circle, circle)</literal></entry></row>
     <row><entry><literal>&amp;&lt;| (circle, circle)</literal></entry></row>
     <row><entry><literal>|&amp;&gt; (circle, circle)</literal></entry></row>

     <row>
      <entry valign="middle" morerows="10"><literal>inet_ops</literal></entry>
      <entry><literal>&lt;&lt; (inet, inet)</literal></entry>
      <entry valign="middle" morerows="10"></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>&lt;&gt; (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><literal>&amp;&amp; (inet, inet)</literal></entry></row>

     <row>
      <entry valign="middle" morerows="17"><literal>multirange_ops</literal></entry>
      <entry><literal>= (anymultirange, anymultirange)</literal></entry>
      <entry valign="middle" morerows="17"></entry>
     </row>
     <row><entry><literal>&amp;&amp; (anymultirange, anymultirange)</literal></entry></row>
     <row><entry><literal>&amp;&amp; (anymultirange, anyrange)</literal></entry></row>
     <row><entry><literal>@&gt; (anymultirange, anyelement)</literal></entry></row>
     <row><entry><literal>@&gt; (anymultirange, anymultirange)</literal></entry></row>
     <row><entry><literal>@&gt; (anymultirange, anyrange)</literal></entry></row>
     <row><entry><literal>&lt;@ (anymultirange, anymultirange)</literal></entry></row>
     <row><entry><literal>&lt;@ (anymultirange, anyrange)</literal></entry></row>
     <row><entry><literal>&lt;&lt; (anymultirange, anymultirange)</literal></entry></row>
     <row><entry><literal>&lt;&lt; (anymultirange, anyrange)</literal></entry></row>
     <row><entry><literal>&gt;&gt; (anymultirange, anymultirange)</literal></entry></row>
     <row><entry><literal>&gt;&gt; (anymultirange, anyrange)</literal></entry></row>
     <row><entry><literal>&amp;&lt; (anymultirange, anymultirange)</literal></entry></row>
     <row><entry><literal>&amp;&lt; (anymultirange, anyrange)</literal></entry></row>
     <row><entry><literal>&amp;&gt; (anymultirange, anymultirange)</literal></entry></row>
     <row><entry><literal>&amp;&gt; (anymultirange, anyrange)</literal></entry></row>
     <row><entry><literal>-|- (anymultirange, anymultirange)</literal></entry></row>
Title: Built-in GiST Operator Classes
Summary
The table lists the built-in GiST operator classes for various data types, including box, circle, inet, and multirange operations, with their respective indexable and ordering operators, providing a comprehensive overview of the available operator classes for GiST indexing.