[postgis-users] Multipolygons to Polygons

[Leticia]

Can I separate the polygons that conform a multipolygon from SQL?

 

For example, If I query

 

SELECT AsText(ogc_geom) as poli from test_table 

I get: 
MULTIPOLYGON(((580525.37 141603.2,580523.3 141629.81,580539.66
141631.09,580540.93 141619.38,580541.46 141608.63,580541.48
141604.73,580525.37 141603.2),(580527.79 141607.36,580532.68
141607.38,580532.61 141622.27,580527.73 141622.26,580527.79 141607.36))) 

which consists of 2 polygons....

 

Can I run a SQL that let me obtain the two separate polygons?

 

Thanks in advance,

Leticia

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