<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Shreyes,<br>
<br>
you have to create a new table and then insert the result of the
st_intersect in the new table, e.g. like this:<br>
<br>
insert into new_table<br>
select a.id, b.id, st_intersect(a.the_geom, b.the_geom)<br>
from<br>
table_a a<br>
inner join<br>
table_b b<br>
on a.the_geom && b.the_geom<br>
where st_intersects(a.the_geom, b.the_geom);<br>
<br>
Hope that helps,<br>
<br>
Birgit.<br>
<br>
<br>
Am 04.05.2011 07:14, schrieb shreyes shiv:
<blockquote
cite="mid:BANLkTimUo9UP1jO3dC_F_JwyAk+NzuXd9g@mail.gmail.com"
type="cite">Dear all,
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>Please help</div>
<div><br>
</div>
<div> <br clear="all">
<br>
-- <br>
shreyes shiv<br>
email: <a moz-do-not-send="true"
href="mailto:shivshreyes@gmail.com">shivshreyes@gmail.com</a><br>
phone: 9557975780<br>
IIRS(Indian Institute of Remote Sensing)<br>
No. 4, Kalidas Road, Dehradun-248001, Uttarakhand, India<br>
</div>
</blockquote>
</body>
</html>