[postgis-users] ST_Intersects

[Birgit Laggner]

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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>