No subject

geometries are passed between functions by-value. So invoking GeometryN N
times becomes rather expensive for large geometries.

ST_Dump returns an array of information from which you can easily extract
the parts:

  SELECT dump.geom FROM ST_Dump(orig_geom) as dump;

-- 
Helge Jensen
Partner & Senior Software Developer

--000e0ce03f6af3e6a60478788011
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I just wanna inject a comment about performance here.<br>
<br>
Using GeometryN (or ST_GeometryN) incurs a significant penalty,
especially in terms of memory when i was using it. ST_Dump performs
*much* better.<br>
<br>