<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Exchange Server">
<!-- converted from text --><style><!-- .EmailQuote { margin-left: 1pt; padding-left: 4pt; border-left: #800000 2px solid; } --></style>
</head>
<body>
<meta content="text/html; charset=UTF-8">
<style type="text/css" style="">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
</style>
<div dir="ltr">
<div id="x_divtagdefaultwrapper" dir="ltr" style="font-size:12pt; color:#000000; font-family:Calibri,Helvetica,sans-serif">
<p>Paul's posts are usually a helpful start:</p>
<p><a href="https://carto.com/blog/lateral-joins" class="x_OWAAutoLink" id="LPlnk310440">https://carto.com/blog/lateral-joins</a></p>
<p><br>
</p>
<p><#> 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.<br>
</p>
<p><br>
</p>
<p>Really, now all you need is: <-> and a lateral join.</p>
<p><br>
</p>
<p>Cheers,</p>
<p>Best,</p>
<p>Steve<br>
</p>
<p><br>
</p>
<div id="x_Signature">
<div id="x_divtagdefaultwrapper" style="font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255); font-family:Calibri,Arial,Helvetica,sans-serif,"EmojiFont","Apple Color Emoji","Segoe UI Emoji",NotoColorEmoji,"Segoe UI Symbol","Android Emoji",EmojiSymbols">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div style="font-family:Tahoma; font-size:13px">
<div class="x_WordSection1">
<p class="x_MsoNormal"><img alt="http://sig.cmparks.net/cmp-ms-90x122.png" width="90" hspace="12" height="122" align="left" src="http://sig.cmparks.net/cmp-ms-90x122.png">
<span style="font-size:14pt; color:rgb(0,108,86); font-family:Helvetica,sans-serif">
<span style="font-family:Helvetica,sans-serif"><strong>Stephen V. Mather</strong></span><br style="font-family:Helvetica,sans-serif">
<span style="font-family:Helvetica,sans-serif"></span></span><span style="font-size:11pt; color:rgb(0,108,86); font-family:Helvetica,sans-serif"><span style="font-family:Helvetica,sans-serif">GIS Manager</span><br style="font-family:Helvetica,sans-serif">
<span style="font-family:Helvetica,sans-serif"></span></span><span style="font-size:9pt; color:rgb(0,108,86); font-family:Helvetica,sans-serif"><span style="font-family:Helvetica,sans-serif">(216) 635-3243 (Work)
</span></span><span style="font-size:11pt; color:rgb(31,73,125); font-family:Helvetica,sans-serif"><a target="_blank" href="http://www.clemetparks.com" tabindex="0" id="LPNoLP"><span style="font-family:Helvetica,sans-serif"><br style="font-family:Helvetica,sans-serif">
<span style="font-family:Helvetica,sans-serif">clevelandmetroparks.com</span></span></a></span></p>
<p class="x_MsoNormal"></p>
<br>
<br>
<br>
</div>
</div>
<div></div>
</div>
</div>
</div>
</div>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> postgis-users <postgis-users-bounces@lists.osgeo.org> on behalf of Matthew Baker <mattbaker@gmail.com><br>
<b>Sent:</b> Monday, July 3, 2017 11:29:15 AM<br>
<b>To:</b> PostGIS Users Discussion<br>
<b>Subject:</b> [postgis-users] Documentation on <#> and <-> operators</font>
<div> </div>
</div>
</div>
<font size="2"><span style="font-size:10pt;">
<div class="PlainText">Hi all!<br>
<br>
I'm trying to figure out what the <#> and <-> operators mean with PostGIS.<br>
<br>
I have gotten them to work but I'm not exactly sure what is going on <br>
under the hood... and also, for whatever reason, cannot seem to use <br>
those operators as search terms for GIS.SE, Google, etc.<br>
<br>
Thanks!<br>
<br>
Matt Baker<br>
Denver Public Schools<br>
Denver, CO<br>
mattbaker@gmail.com<br>
<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
postgis-users@lists.osgeo.org<br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></div>
</span></font>
</body>
</html>