[postgis-users] Split multi-linestrings

[Andrea Peri 2007]

Hi Frank,

thx for suggestion.

I try with ST_Dump using:

(ST_Dump(geom)).geom 

But unfortunately it give me again all segments with only 2 vertex :(

So from 1 MultiLineString with 2 parts each with 20+ vertex give me many LineStrings with only 2 vertex each :(


Andrea.

>Hi Andrea,
>Have a look to ST_Dump
>http://postgis.refractions.net/docs/ST_Dump.html
>
>Fred

>>/ I try this code with postgis 1.4.0:
/>>
>//>/ ST_GeometryN(geom,generate_series(1,ST_NumGeometries(geom)))
/>>
>>/// But it return all LineStrings as simple segments with 2 only vertexs.

/