I want to create a LINESTRING from a MULTILINESTRING. However in the following case
ST_MultiLineString is returned:
Select ST_GeometryType(ST_LineMerge(ST_AsText(' MULTILINESTRING( (-70.52570888 -33.48112668,-70.52552472 -33.48116414), (-70.52552472 -33.48116414,-70.52453208 -33.48121471,-70.52552472 -33.48116414) )')));
Why is this the case? The linestrings are not self intersecting and are connected. How can I resolve this?