[postgis-users] function from multilinestring to linestring

[toni hernnadez]

hi,
Is there any way to convert a multilinestring object to linestring?

Christo Du Preez wrote:

> That is fantastic! Thanx very much.
>
> Markus Schaber wrote:
>
>> Hi, Christo,
>>
>> Christo Du Preez wrote:
>>
>>  
>>
>>> Is there a way to return multiple records querying a single record with
>>> a multipoint geometry? In other words, I'd like to return a row for 
>>> each
>>> point in the multipoint geometry.
>>>     
>>
>>
>> Yes, there is. Try something like:
>>
>> SELECT GeometryN(the_geom,generate_series(1,numGeometries(the_geom)))
>> FROM table;
>>
>> HTH,
>> Markus
>>   
>
>