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

[Stephen V. Mather]

Paul's posts are usually a helpful start:

https://carto.com/blog/lateral-joins


<#> 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.


Cheers,

Best,

Steve


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



________________________________
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.

Thanks!

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


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