[postgis-users] How can I split a polyline?

[Amit Kulkarni]

On 3/7/06, Robert Burgholzer <rburghol at chesapeakebay.net> wrote:
> An possibly:
>
> geometryN(geometry, integer)
>
> for extracting sub-geometries in a true multi-line.
>
> r.b.

My bad. Sorry, I meant to paste geometryN but NumPoints came about, the
copy paste operation got awry!

Fay, here is the loop you can build upon

max_limit := NumGeometries(collect_polys);
IF collect_polys IS NULL OR max_limit <= 0 THEN
     RETURN NULL;
END IF;

WHILE i <= max_limit LOOP
         collect_polygons[i] := GeometryN(collect_polys, i);
	 i := i + 1;
END LOOP;

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com