<html>
<head>
</head>
<body style="margin-left: 4px; margin-top: 4px; margin-bottom: 1px; font-weight: normal; font-size: 12pt; font-variant: normal; margin-right: 4px; font-family: Comic Sans MS; line-height: normal; font-style: normal">
<br> <br>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Comic Sans MS">I'll wait for the proof I think. Just now starting to work with POSTGIS, and historically, large datasets have worked faster (for me) for this type of query when worked against a tabular numeric column. If speed of return is the primary constraint . . .</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Comic Sans MS">I'll gladly jump on the wagon that this is not so with POSTGIS. I don't have a 21 million record dataset to test with however. :c)</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<font size="3" face="Comic Sans MS">bobb</font> </p>
<br>
<p style="margin-top: 0; margin-bottom: 0">
<br>
<br>
>>> "Mr. Puneet Kishor" <punk.kish@gmail.com> wrote:<br> </p>
<table border="0" bgcolor="#f3f3f3" style="margin-left: 15px; margin-top: 0; margin-bottom: 0; font-size: 1em; margin-right: 0">
<tr>
<td>
<div style="border-left: solid 1px #050505; padding-left: 7px">
<p style="margin-top: 0; margin-bottom: 0">
<br>
On Mar 7, 2012, at 11:36 AM, Bob Basques wrote:<br><br>> if (x > minx && x < max && y > miny && y < maxy) then true. .<br><br><br><br>This is precisely the kind of problem that GiST solves. The above query is not likely to be better than a spatial query.<br><br><br><br><br>--<br>Puneet Kishor<br>_______________________________________________<br>postgis-users mailing list<br>postgis-users@postgis.refractions.net<br><a href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</p>
</div>
</td>
</tr>
</table>
</body>
</html>