[postgis-users] function from multilinestring to linestring

[Markus Schaber]

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
-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org