geometries are passed between functions by-value. So invoking GeometryN N times becomes rather expensive for large geometries.<br> <br> ST_Dump returns an array of information from which you can easily extract t= he parts:<br> <br> =C2=A0 SELECT dump.geom FROM ST_Dump(orig_geom) as dump;<br clear=3D"all"><= br>-- <br>Helge Jensen<br>Partner & Senior Software Developer<br><br><b= r> --000e0ce03f6af3e6a60478788011--