Home Explore Blog CI



postgresql

3rd chunk of `doc/src/sgml/gist.sgml`
b95a9465e7e3a3c0f9de227f0f8b97b03dd5f860be7802ec0000000100000fa9
 (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>
     <row><entry><literal>-|- (anymultirange, anyrange)</literal></entry></row>

     <row>
      <entry valign="middle" morerows="7"><literal>point_ops</literal></entry>
      <entry><literal>|&gt;&gt; (point, point)</literal></entry>
      <entry valign="middle" morerows="7"><literal>&lt;-&gt; (point, point)</literal></entry>
     </row>
     <row><entry><literal>&lt;&lt; (point, point)</literal></entry></row>
     <row><entry><literal>&gt;&gt; (point, point)</literal></entry></row>
     <row><entry><literal>&lt;&lt;| (point, point)</literal></entry></row>
     <row><entry><literal>~= (point, point)</literal></entry></row>
     <row><entry><literal>&lt;@ (point, box)</literal></entry></row>
     <row><entry><literal>&lt;@ (point, polygon)</literal></entry></row>
     <row><entry><literal>&lt;@ (point, circle)</literal></entry></row>

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

     <row>
      <entry valign="middle" morerows="17"><literal>range_ops</literal></entry>
      <entry><literal>= (anyrange, anyrange)</literal></entry>
      <entry valign="middle" morerows="17"></entry>
     </row>
     <row><entry><literal>&amp;&amp; (anyrange, anyrange)</literal></entry></row>
     <row><entry><literal>&amp;&amp; (anyrange, anymultirange)</literal></entry></row>
     <row><entry><literal>@&gt; (anyrange, anyelement)</literal></entry></row>
     <row><entry><literal>@&gt; (anyrange, anyrange)</literal></entry></row>
     <row><entry><literal>@&gt; (anyrange, anymultirange)</literal></entry></row>
     <row><entry><literal>&lt;@ (anyrange, anyrange)</literal></entry></row>
     <row><entry><literal>&lt;@ (anyrange, anymultirange)</literal></entry></row>
     <row><entry><literal>&lt;&lt; (anyrange, anyrange)</literal></entry></row>
     <row><entry><literal>&lt;&lt; (anyrange, anymultirange)</literal></entry></row>
     <row><entry><literal>&gt;&gt; (anyrange, anyrange)</literal></entry></row>

Title: PostgreSQL Operator Classes
Summary
The table lists various operator classes in PostgreSQL, including point, polygon, range, and multirange operations, with their respective indexable and ordering operators, providing a comprehensive overview of the available operator classes for different data types.