[postgis-users] ST_Intersects

[Birgit Laggner]

Hi Shreyes,

you have to create a new table and then insert the result of the 
st_intersect in the new table, e.g. like this:

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);

Hope that helps,

Birgit.


Am 04.05.2011 07:14, schrieb shreyes shiv:
> Dear all,
>
> I want to use the ST_Intersect on two tables. I want the resultant of 
> the ST_Intersect to form a new table. How do i do that.
>
> Please help
>
>
>
> -- 
> shreyes shiv
> email: shivshreyes at gmail.com <mailto:shivshreyes at gmail.com>
> phone: 9557975780
> IIRS(Indian Institute of Remote Sensing)
> No. 4, Kalidas Road, Dehradun-248001, Uttarakhand, India
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110504/4a453d0e/attachment.html>