Hi Sandro,
Am 04.05.2011 11:49, schrieb Sandro Santilli:
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)
yes!! this was a typo :-)
... and I'd add ( a.id> b.id ) in the WHERE condition.
But why this, if table_a and table_b are different tables??
Regards,
Birgit.
--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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
