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

From Scott Ding
Subject point <-> polygon not supported?
Date
Msg-id E8EF167E598AD74381DD26B7F315098A1C988D@msgpetmb1.amer.ads.autodesk.com
Whole thread Raw
List pgsql-sql

I’m using version 7.3.2. I got the following error when I executed the sql statement in psql:

 

llogicdb=> select ID, POINAME, ADDRESS, (GEOM::point <-> polygon('((-122.406903

, 37.785768),(-122.405903, 37.785768),(-122.405903, 37.786768),(-122.406903, 37

.786768))')) * 87878.15460046429 as CFF_DISTANCE from NT_SF_POI where (FACILITY

TYPE='3578') and (GEOM::point <-> polygon('((-122.406903, 37.785768),(-122.4059

03, 37.785768),(-122.405903, 37.786768),(-122.406903, 37.786768))')) * 87878.15

460046429 <= 3.41381770434236E-5 order by CFF_DISTANCE;

ERROR:  Unable to identify an operator '<->' for types 'point' and 'polygon'

        You will have to retype this query using an explicit cast

 

Does this mean that the <-> operator does not support distance between a point and a simple polygon?

 

Scott Ding

pgsql-sql by date:

Previous
From: JBJ
Date:
Subject: once again, sorting with Unicode
Next
From: Josh Berkus
Date:
Subject: Re: Drop temporary table only if it exists