I have a region_polygons table where region_polygons.rpg_geom is a MULTIPOLYGON. I want to select rows in the geom_table where geom_table.geom_fld is within region_polygons.rpg_geom
The following idiom works for me, but is waaaay slow (whereas I found other kinds of spatial queries are pretty zippy): SELECT * from geom_table where EXISTS (select rpg_id from region_polygons where geom_fld && rpg_geom and intersects(geom_fld, rpg_geom) and rpg_name='GVRD_OLD') Where should I start? a) Simplify the multipolygon? b) Joins instead of EXISTS? c) Would putting the literal WK format for the polygon right into the SQL query help? d) ... or something else? -- Robin R Chauhan Pathway Intelligence Inc [EMAIL PROTECTED] 604-886-3964
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users