<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div><div class="MsoNormal">Hello.<o:p></o:p></div>
<div class="MsoNormal"><o:p> </o:p></div>
<div class="MsoNormal"><span lang="EN-US">I need to
build a view that contains data of accumulated contribution to the sewage
network (linestrings). Each section of the sewer system has its own
contribution. I need a function (i think this is the only way to solve this,
but if have another way, please tell me) to calculate that cumulative
contribution. The function would have to add cumulative values of the
contributions of previous linestrings to the local contribution (WHERE
st_touches(st_startpoint(sewer1.geom), st_endpoint(sewer2.geom)) until the
“end” (the top/start of sewage network, where don’t have another previous
linestring. I think a WHILE solve this, but how?). Can anyone help me?<o:p></o:p></span></div>
<div class="MsoNormal"><span lang="EN-US"> </span></div>
<div class="MsoNormal"><span lang="EN-US">Thanks.<o:p></o:p></span></div>
<div class="MsoNormal"><span lang="EN-US"> </span></div>
<div class="MsoNormal"><span lang="EN-US">Delton
Moraes<o:p></o:p></span></div></div></div></body></html>