On Dec 4, 2008, at 3:07 PM, Dylan Beaudette wrote:
Can you show us your queries?
Some of these examples look a little funny -- i.e. did you query
contain the
ST_xxx() function in the JOIN condition and the gometry construction?
-- like this:
select st_intersection(a,b) from t1 join t2
on st_intersects(a,b) ;
There's only 1 table. Is Qgis, I added a where clause to the
connection:
where ST_Intersects(wkb_geometry, SetSRID('BOX3D(-162 55,-161
56)'::box3d,4326))
Qgis takes care of the rest of the details, but it probably comes out
as something like:
select * from swbd where ST_Intersects(wkb_geometry,
SetSRID('BOX3D(-162 55,-161 56)'::box3d,4326));
-----
William Kyngesburye <kyngchaos*at*kyngchaos*dot*com>
http://www.kyngchaos.com/
"Oh, look, I seem to have fallen down a deep, dark hole. Now what
does that remind me of? Ah, yes - life."
- Marvin
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users