Damn right man - <span></span>thanks!<br><br>On Saturday, November 1, 2014, Sandro Santilli <<a href="mailto:strk@keybit.net">strk@keybit.net</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On Fri, Oct 31, 2014 at 05:12:40PM -0400, Robert Burgholzer wrote:<br>
> So just for accuracy, I was incorrect, sort of.  While the functions that I<br>
> am currently using "contains, within, ..." will do the CAST implicitly, the<br>
> GIST index does not like the bytea type.  Which makes the adoption of an<br>
> actual geometry column even more urgent.<br>
<br>
For further accuracy, you might pass the GiST index an expression, then<br>
it'll like it. Example:<br>
<br>
 create index on mytable using gist (geometry(mybytea));<br>
 explain select gid from mytable where mybytea && ST_MakeEnvelope(0,0,1,1);<br>
<br>
--strk;<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="javascript:;" onclick="_e(event, 'cvml', 'postgis-users@lists.osgeo.org')">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</blockquote><br><br>-- <br><div dir="ltr">--<br>Robert W. Burgholzer<br> 'Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that's creativity.'  - Charles Mingus<div>Athletics: <a href="http://athleticalgorithm.wordpress.com/" target="_blank">http://athleticalgorithm.wordpress.com/</a> <br></div><div>Science: <a href="http://robertwb.wordpress.com/" target="_blank">http://robertwb.wordpress.com/</a></div><div>Wine: <a href="http://reesvineyard.wordpress.com/" target="_blank">http://reesvineyard.wordpress.com/</a></div></div><br>