[postgis-users] ST_GeomFromText vs ST_MakeEnvelope

[John Cartwright]

Hello All,

I'm trying to understand why I get different results in PostGIS 2.1/Postgresql 9.2. using the following queries:

select name, ST_AsText(a.geom) as geom from cities a where a.geom && ST_MakeEnvelope(-107,39, -102, 42, 4326);

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);

Can someone please explain?

Thanks!

--john

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131001/0d793c6b/attachment.html>