<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3243" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2>Hi all,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2> i´ve got a
problem with ST_Dump() ( well, actually this one doesn´t exist )</FONT></DIV>
<DIV><FONT face=Arial size=2>and dump() function. I´m working with</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>"PostgreSQL 8.2.3 on i686-pc-mingw32, compiled by
GCC gcc.exe (GCC) 3.4.2 (mingw-special)"</FONT></DIV>
<DIV><FONT face=Arial size=2>"POSTGIS="1.2.1" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel.
4.5.0, 22 Oct 2006" USE_STATS"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I want to convert linestrings from
multilinestrings, with linemerge, to obtain united linestrings
in overlapping points</FONT></DIV>
<DIV><FONT face=Arial size=2>with this sentence:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>select dump(linemerge(collect(the_geom))) from
lines</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>but i obtain:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>ERROR: set-valued function called in context that
cannot accept a set<BR>Estado SQL:0A000<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>T</FONT><FONT face=Arial size=2>he result of:</DIV>
<DIV> </DIV>
<DIV>select astext(LineMerge(Collect(the_geom))) from lines</DIV>
<DIV> </DIV>
<DIV>is:</DIV>
<DIV><BR></FONT><FONT face=Arial size=2>"MULTILINESTRING((4.8938679245283
46.3443396226415,33.313679245283 73.7028301886792,49.5872641509434
80.0707547169811,90.9583136792453 89.2813679245283,54.3363797169811
103.03608490566,29.0620872641509 103.293985849057,12.2125589622641
107.1625,11.1624233831055 106.590266209164,10.4214805264064
107.529010012923,11.2220067193803 108.417488521584,12.2326314413493
107.778056025276),(37.506947728971 97.6302534161404,12.1756482134062
82.9892270906306))"</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>with numgeometries=2, the logic result with my
original data.</FONT></DIV>
<DIV><FONT face=Arial size=2>How can i extract those
linestrings separately?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Gus<BR></DIV></FONT></BODY></HTML>