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: [email protected] <mailto:[email protected]>
phone: 9557975780
IIRS(Indian Institute of Remote Sensing)
No. 4, Kalidas Road, Dehradun-248001, Uttarakhand, India
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
