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