[postgis-users] function from multilinestring to linestring

[toni hernnadez]

hi,

in case all the multilinestring overlap (I checked) is there another way 
to do it.
I've tried GeomUnion but it returns multilinestring again.
I couldn't try linemerge. It seems that in my version in not such a function

Markus Schaber wrote:

>Hi, Toni,
>
>toni hernnadez wrote:
>
>  
>
>>Is there any way to convert a multilinestring object to linestring?
>>    
>>
>
>Not generally, as a LineString contains exactly _one_ sequence of
>connected points, and a MultiLineString can contain more of them.
>
>For some corner cases (e. G. adjacent or overlapping LineStrings) you
>can try LineMerge() or GeomUnion() to connect the pieces together.
>
>The first LineString in a MultiLineString can be fetched via
>GeometryN(yourlinestring,1).
>
>
>HTH,
>Schabi
>  
>