point <-> polygon not supported? - Mailing list pgsql-sql

<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I’m using version 7.3.2. I got the following error when I executed the <span
class="SpellE">sql</span>statement in psql: </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><span class="SpellE"><span class="GramE"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;font-family:Arial">llogicdb</span></font></span></span><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;font-family:Arial">=> select ID, POINAME, ADDRESS, (<span
class="SpellE">GEOM::point</span><-> polygon('((-122.406903</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">, 37.785768)<span class="GramE">,(</span>-122.405903, 37.785768),(-122.405903,
37.786768),(-122.406903,37</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">.786768))')) * 87878.15460046429 as CFF_DISTANCE from NT_SF_POI where (FACILITY</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">TYPE='3578') and (<span class="SpellE">GEOM::point</span> <-> <span
class="GramE">polygon(</span>'((-122.406903,37.785768),(-122.4059</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">03, 37.785768)<span class="GramE">,(</span>-122.405903, 37.786768),(-122.406903, 37.786768))')) *
87878.15</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial">460046429 <= 3.41381770434236E-5 order by CFF_DISTANCE;</span></font><p class="MsoNormal"><font
face="Arial"size="2"><span style="font-size:10.0pt; 
font-family:Arial">ERROR:<span style="mso-spacerun:yes">  </span>Unable to identify an operator '<->' for types
'point'and 'polygon'</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"><span style="mso-spacerun:yes">        </span>You will have to retype this query using an explicit
cast</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Does this mean that the <-> operator does not support distance between a point and a simple
polygon?</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial">ScottDing</span></font><font face="Arial" size="2"><span
style="font-size:10.0pt;font-family:Arial"></span></font></div>