[postgis-users] Documentation on <#> and <-> operators

Stephen V. Mather svm at clevelandmetroparks.com
Mon Jul 3 08:55:02 PDT 2017

Paul's posts are usually a helpful start:


<#> is approximate (i.e. on bounding boxes) and was useful before PostgreSQL 9.5, as it could be used in a two step process to get the exact answer.

Really, now all you need is: <-> and a lateral join.




[http://sig.cmparks.net/cmp-ms-90x122.png] Stephen V. Mather
GIS Manager
(216) 635-3243 (Work)

From: postgis-users <postgis-users-bounces at lists.osgeo.org> on behalf of Matthew Baker <mattbaker at gmail.com>
Sent: Monday, July 3, 2017 11:29:15 AM
To: PostGIS Users Discussion
Subject: [postgis-users] Documentation on <#> and <-> operators

Hi all!

I'm trying to figure out what the <#> and <-> operators mean with PostGIS.

I have gotten them to work but I'm not exactly sure what is going on
under the hood... and also, for whatever reason, cannot seem to use
those operators as search terms for GIS.SE, Google, etc.


Matt Baker
Denver Public Schools
Denver, CO
mattbaker at gmail.com

postgis-users mailing list
postgis-users at lists.osgeo.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20170703/510830f7/attachment.html>

More information about the postgis-users mailing list