Hi, Thinking (falsely) that I would cleverly locate where two sets of polygons did not overlap, I gave something like this a try:
CREATE TABLE big_mistake as SELECT a.something, b.something FROM a JOIN b ON ST_Instersects(a,b) = FALSE; ... postgresql then proceeded to fill my harddrive with garbage! Note the self: don't try seemingly clever tricks without first *thinking* about them. Dylan -- Dylan Beaudette Soil Resource Laboratory http://casoilresource.lawr.ucdavis.edu/ University of California at Davis 530.754.7341 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users