Hello i am an newby and i am trying to make a contains query. the problem is that my tables are to big to pull the query in one (248000 polygon and 105000 points). my original query: create table osm_in_50 as SELECT gr.gid, gr.name, gr.feattyp, b.id FROM buffer_50 AS gr, osm_poi AS b WHERE Contains ( gr.setsrid, b.geom_900913 ) = TRUE;
i tried to construct a cursor for this and it worked on a small table but for the big one it doesnt seem to work. it was running for allmost 12 hoers: declare my_cursor cursor for select * from buffer_50; FETCH FORWARD 1000 FROM my_cursor; declare my_cursor2 cursor for select *from osm_poi; FETCH FORWARD 1000 FROM my_cursor2; create table osm_in_50 as SELECT gr.gid, gr.name, gr.feattyp, b.id FROM buffer_50 AS gr, osm_poi AS b WHERE Contains ( gr.setsrid, b.geom_900913 ) = TRUE; close my_cursor2; close my_cursor; can someone please help me! alex -- Jetzt kostenlos herunterladen: Internet Explorer 8 und Mozilla Firefox 3 - sicherer, schneller und einfacher! http://portal.gmx.net/de/go/atbrowser _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
