I'm running PostGIS 2.0 for PostGreSQL 9.2, and I have a customer who wants to know how close a provided geometry is to the nearest feature in a table. So I'm playing around with the "<->" and "<#>" operators. My problem? The "<#>" operator isn't recognized.
SELECT gid, the_geom <-> ST_GeomFromEWKT('<my geometry>') FROM "<my table>" ;
This does not:
SELECT gid, the_geom <#> ST_GeomFromEWKT('<my geometry>') FROM "<my table>" ;
I get an error:
ERROR: operator does not exist: geometry <#> geometry
Am I missing something obvious?