[postgis-users] ST_Intersects

Sandro Santilli strk at keybit.net
Wed May 4 02:49:39 PDT 2011


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



More information about the postgis-users mailing list