On Wed, May 04, 2011 at 09:30:01AM +0200, Birgit Laggner wrote: > insert into new_table > select a.id, b.id, st_intersect(a.the_geom, b.the_geom) > from > table_a a > inner join > table_b b > on a.the_geom && b.the_geom > where st_intersects(a.the_geom, b.the_geom); - st_intersect(a.the_geom, b.the_geom) + st_intersection(a.the_geom, b.the_geom)
... and I'd add ( a.id > b.id ) in the WHERE condition. --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
