[postgis-users] Intersection not implemented for Multipolygon ?

["R. Müller"]

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
********************************************************