In a previous posting, I saw the following suggestion: > > ...you could do something like this: > select count(*) > from > public.table1 as a, > public._sample_extent as b > where > ST_Intersects(a.geom,b.geom)=true >
I was wondering, doesn't "WHERE ST_Intersects(a.geom,b.geom)" have the same output as "WHERE ST_Intersects(a.geom,b.geom)=true" and wouldn't it actually be more real time efficient to do the first one, since you don't have to do the extra check with whether it is equal to true or not? Or is the PostgreSQL compiler smart enough to make the two exactly the same when it comes to efficiency? Regards, Loretta _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
