<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span style="color: rgb(34, 34, 34); font-family: arial; font-size: small; background-color: rgb(255, 255, 255); ">Hello All,</span><div style="color: rgb(34, 34, 34); font-family: arial; font-size: small; "><br></div><div style="color: rgb(34, 34, 34); font-family: arial; font-size: small; ">I'm trying to understand why I get different results in <span style="font-family: arial, sans-serif; white-space: nowrap; ">PostGIS 2.1/Postgresql 9.2. </span>using the following queries:</div><div style="color: rgb(34, 34, 34); font-family: arial; font-size: small; "><br></div><div style="color: rgb(34, 34, 34); font-family: arial; font-size: small; "><div><font face="arial, sans-serif"><span style="white-space: nowrap; ">select name, ST_AsText(a.geom) as geom from cities a where a.geom && ST_MakeEnvelope(-107,39, -102, 42, 4326);</span></font></div><div><span style="white-space: nowrap; font-family: arial, sans-serif; "><br></span></div><div><span style="white-space: nowrap; font-family: arial, sans-serif; ">select name, ST_AsText(a.geom) as geom from cities a where a.geom && ST_GeomFromText('POLYGON((-107 39, -102 39, -102 42, -17 42, -107 39))', 4326);</span><br></div></div><div style="color: rgb(34, 34, 34); font-family: arial; font-size: small; "><br></div><div style="color: rgb(34, 34, 34); font-family: arial; font-size: small; ">Can someone please explain?</div><div style="color: rgb(34, 34, 34); font-family: arial; font-size: small; "><br></div><div style="color: rgb(34, 34, 34); font-family: arial; font-size: small; ">Thanks!</div><div style="color: rgb(34, 34, 34); font-family: arial; font-size: small; "><br></div><div style="color: rgb(34, 34, 34); font-family: arial; font-size: small; ">--john</div><div style="color: rgb(34, 34, 34); font-family: arial; font-size: small; "><br></div></body></html>