<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">I was just working through strategy numbers and thinking about how we only ever use RTOverlapStrategyNumber when I realized that we should be using other strategies for at least a few of our functions, and yet we have </div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="margin: 0px;"><div id="bloop_customfont" style="margin: 0px;">CREATE OR REPLACE FUNCTION ST_Contains(geom1 geometry, geom2 geometry)</div><div id="bloop_customfont" style="margin: 0px;"> RETURNS boolean</div><div id="bloop_customfont" style="margin: 0px;"> AS 'SELECT $1 && $2 AND _ST_Contains($1,$2)'</div><div id="bloop_customfont" style="margin: 0px;"> LANGUAGE 'sql' IMMUTABLE;</div><div style="color: rgb(0, 0, 0); font-family: Helvetica, Arial; font-size: 13px;"><br></div><div style="color: rgb(0, 0, 0); font-family: Helvetica, Arial; font-size: 13px;">When really it should be</div><div style="color: rgb(0, 0, 0); font-family: Helvetica, Arial; font-size: 13px;"><br></div><div><div>CREATE OR REPLACE FUNCTION ST_Contains(geom1 geometry, geom2 geometry)</div><div> RETURNS boolean</div><div> AS 'SELECT $1 ~ $2 AND _ST_Contains($1,$2)'</div><div> LANGUAGE 'sql' IMMUTABLE;</div><div style="color: rgb(0, 0, 0); font-family: Helvetica, Arial; font-size: 13px;"><br></div></div></div>Probably a small efficiency savings to be had in reducing the number of geometries to be exact tested. Anyone see a reason we shouldn’t do this?<div><br></div><div>P.<br><div id="bloop_sign_1411768096253304064" class="bloop_sign">
<title></title>
<div>
<br>
</div>
-- <br>
Paul Ramsey<br>
http://cleverelephant.ca<div>http://postgis.net
</div>
<script type="application/ld+json">
{
"@context": "http://schema.org",
"@type": "em",
"name": "John Doe",
"jobTitle": "Graduate research assistant",
"affiliation": "University of Dreams",
"additionalName": "Johnny",
"url": "http://www.example.com",
"address": {
"@type": "PostalAddress",
"streetAddress": "1234 Peach Drive",
"addressLocality": "Wonderland",
"addressRegion": "Georgia"
}
}
</script>
</div></div></body></html>