[postgis-users] INTERSECT TWO TABLES

[Erwan Bocher]

Hi,



I'm novice in POSTGIS. I'd like to intersect two tables witch contains polygons. The query must return another table with all polygon intersection.

 

I've used this query :

 

select intersection((select the_geom from parcelle1),(select the_geom from parcelle2)) into tabintersection;

 

but return error "more than one row returned by a subquery used as an expression"

 

Could you help me ?

 

Thanks



Erwan

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20040404/ff856fae/attachment.html>