[postgis-users] Intersection not implemented for Multipolygon ?

strk at refractions.net strk at refractions.net
Fri May 13 07:23:21 PDT 2005


You should be able to intersect two multipolygons (and see a
result if they DO intersect). If you find a discrepancy please
send a test case.

--strk;

On Fri, May 13, 2005 at 02:02:11PM +0200, "R. Müller" wrote:
> Hi Group,
> 
> imagine following query:
> 
> select astext(intersection(geom,boxgeom)) from table;
> 
> 'table' is a table with a geometry-column of type 'geometry' because it 
> mix up polygons and multipolygons.
> that means in the query above column 'geom' contains polygon and 
> multipolygons.
> the boxgeom to intersect with is a simple constant box as a geometry.
> the resultset contains only values for the polygons not for the 
> multipolygons, but throws no exceptions.
> i use postgres 7.4.7 and postgis 1.0RC2 with geos and proj4.
> 
> any hint ?
> 
> should i use only one geometry-type per table (for instance converting 
> all polygons to multipolygons) ?
> 
> thanks
> 
> Ronald
> 
> -- 
> *********************************************************
> *M-Unicomp GmbH
> *
> *Ronald Müller
> *
> *Plauener Straße 163-165, Haus 11
> *13053 Berlin
> *
> *fon   : +49 ( 0 ) 30 / 98 69 61 54
> *fax   : +49 ( 0 ) 30 / 98 69 61 55
> *email : r.mueller at unicomp-berlin.de
> *web   : www.unicomp-berlin.de
> ********************************************************
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users



More information about the postgis-users mailing list