I managed to get it working. The only problem is speed. I'm using it in a function and having to test a couple thousand polygons takes ages. I also tried using a temp table, this is also not an option because of the speed issue.
Christo Du Preez wrote: > Sorry to be such a pain. How would I use the dump function? Is there a > sample that I can perhaps study/ > > Nicolas Ribot wrote: > >>> Thanx Nicolas, >>> >>> What if I store my polygons in a geometrycollection instead of a >>> multipolygon and then use the && operator? >>> >>> >> I think it will be the same as working with multipolygons: a >> geometryCollection is one object, and the whole extent of all the >> contained objects will be considered with the && operator. >> >> You really have to to have one object per row in your table in order >> to compare objects. >> >> Nicolas >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://postgis.refractions.net/mailman/listinfo/postgis-users >> >> >> > > -- Christo Du Preez Senior Software Engineer Mecola IT Mobile: +27 [0]83 326 8087 Skype: christodupreez Website: http://www.locateandtrade.co.za _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
