<div dir="ltr"><div class="gmail_quote"><div dir="ltr"><div class="gmail_quote"><div dir="ltr"><div><div style="font-size:12.8px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><div>I always wondered why the n-D indexes (based on GIDX) only support the &&& operator, the three other operators are commented out in the SQL file<br></div><div><br></div><div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial">-- Availability: 2.0.0</div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial">CREATE OPERATOR CLASS gist_geometry_ops_nd</div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="white-space:pre-wrap"> </span>FOR TYPE geometry USING GIST AS</div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="white-space:pre-wrap"> </span>STORAGE<span> </span><span style="white-space:pre-wrap"> </span>gidx,</div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="white-space:pre-wrap"> </span>OPERATOR 3 &&&<span style="white-space:pre-wrap"> </span>,</div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial">--<span style="white-space:pre-wrap"> </span>OPERATOR 6 ~=<span style="white-space:pre-wrap"> </span>,</div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial">--<span style="white-space:pre-wrap"> </span>OPERATOR 7 ~<span style="white-space:pre-wrap"> </span>,</div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial">--<span style="white-space:pre-wrap"> </span>OPERATOR 8 @<span style="white-space:pre-wrap"> </span>,</div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="white-space:pre-wrap"> </span>-- Availability: 2.2.0</div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><span style="white-space:pre-wrap"> </span>OPERATOR 13 <<->> FOR ORDER BY pg_catalog.float_ops,</div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"> [...]</div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><br></div><div style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:12.8px;font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:400;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial">However, in the C code all operations are defined ! For example, <br></div></div></div><div style="font-size:12.8px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><br></div><div style="font-size:12.8px;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial"><div>static inline bool gserialized_gist_consistent_le<wbr>af(GIDX *key, GIDX *query, StrategyNumber strategy)</div><div>{</div><div><span style="white-space:pre-wrap"> </span>bool retval;</div><div><br></div><div><span style="white-space:pre-wrap"> </span>POSTGIS_DEBUGF(4, "[GIST] leaf consistent, strategy [%d], count[%i]",</div><div><span style="white-space:pre-wrap"> </span> strategy, geog_counter_leaf++);</div><div><br></div><div><span style="white-space:pre-wrap"> </span>switch (strategy)</div><div><span style="white-space:pre-wrap"> </span>{</div><div><span style="white-space:pre-wrap"> </span>case RTOverlapStrategyNumber:</div><div><span style="white-space:pre-wrap"> </span>retval = (bool) gidx_overlaps(key, query);</div><div><span style="white-space:pre-wrap"> </span>break;</div><div><span style="white-space:pre-wrap"> </span>case RTSameStrategyNumber:</div><div><span style="white-space:pre-wrap"> </span>retval = (bool) gidx_equals(key, query);</div><div><span style="white-space:pre-wrap"> </span>break;</div><div><span style="white-space:pre-wrap"> </span>case RTContainsStrategyNumber:</div><div><span style="white-space:pre-wrap"> </span>case RTOldContainsStrategyNumber:</div><div><span style="white-space:pre-wrap"> </span>retval = (bool) gidx_contains(key, query);</div><div><span style="white-space:pre-wrap"> </span>break;</div><div><span style="white-space:pre-wrap"> </span>case RTContainedByStrategyNumber:</div><div><span style="white-space:pre-wrap"> </span>case RTOldContainedByStrategyNumber<wbr>:</div><div><span style="white-space:pre-wrap"> </span>retval = (bool) gidx_contains(query, key);</div><div><span style="white-space:pre-wrap"> </span>break;</div><div><span style="white-space:pre-wrap"> </span>default:</div><div><span style="white-space:pre-wrap"> </span>retval = false;</div><div><span style="white-space:pre-wrap"> </span>}</div><div><br></div><div><span style="white-space:pre-wrap"> </span>return (retval);</div><div>}</div></div></div><div><br></div><div>
<div style="font-size:12.8px;text-decoration-style:initial;text-decoration-color:initial;background-color:rgb(255,255,255)">Is the reason for this to cope with the missing dimensions as suggested here ?</div><div style="font-size:12.8px;text-decoration-style:initial;text-decoration-color:initial;background-color:rgb(255,255,255)"><a href="https://lists.osgeo.org/pipermail/postgis-devel/2015-February/024757.html" style="color:rgb(17,85,204)" target="_blank">https://lists.osgeo.org/piperm<wbr>ail/postgis-devel/2015-Februar<wbr>y/024757.html</a></div>
<br></div>Any hint in this respect?<div><br></div><div>Regards</div><span class="m_3543053560441261352HOEnZb"><font color="#888888"><div><br></div><div>Esteban<br clear="all"><div><br></div></div></font></span></div></div><div>-- <br></div><div class="m_3543053560441261352gmail_signature" data-smartmail="gmail_signature">------------------------------<wbr>------------------------------<br>Prof. Esteban Zimanyi<br>Department of Computer & Decision Engineering (CoDE) CP 165/15 <br>Universite Libre de Bruxelles <br>Avenue F. D. Roosevelt 50 <br>B-1050 Brussels, Belgium <br>fax: + 32.2.650.47.13<br>tel: + 32.2.650.31.85<br>e-mail: <a href="mailto:ezimanyi@ulb.ac.be" target="_blank">ezimanyi@ulb.ac.be</a><br>Internet: <a href="http://code.ulb.ac.be/" target="_blank">http://code.ulb.ac.be/</a><br>------------------------------<wbr>------------------------------</div>
</div>
<br></div><br></div>