point <-> polygon not supported?
От | Scott Ding |
---|---|
Тема | point <-> polygon not supported? |
Дата | |
Msg-id | E8EF167E598AD74381DD26B7F315098A1C988D@msgpetmb1.amer.ads.autodesk.com обсуждение исходный текст |
Список | 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>
В списке pgsql-sql по дате отправления: