<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">So I see your data now,</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"> as a table on a mail, and as first glance I "see" that something is wrong,</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">But I need to reproduce your problem, so I need the data in such a way that I can copy paste.</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">So imagine I have a problem and I need you help me finding what is my problem:</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><b>I have this data:</b><br></div><pre><span class="gmail-n">CREATE</span> <span class="gmail-n">TABLE</span> <span class="gmail-n">edge_table</span> <span class="gmail-p">(</span>
<span class="gmail-nb">id</span> <span class="gmail-n">BIGSERIAL</span><span class="gmail-p">,</span>
<span class="gmail-nb">dir</span> <span class="gmail-n">character</span> <span class="gmail-n">varying</span><span class="gmail-p">,</span>
<span class="gmail-n">source</span> <span class="gmail-n">BIGINT</span><span class="gmail-p">,</span>
<span class="gmail-n">target</span> <span class="gmail-n">BIGINT</span><span class="gmail-p">,</span>
<span class="gmail-n">cost</span> <span class="gmail-n">FLOAT</span><span class="gmail-p">,</span>
<span class="gmail-n">reverse_cost</span> <span class="gmail-n">FLOAT</span><span class="gmail-p">,</span>
<span class="gmail-n">capacity</span> <span class="gmail-n">BIGINT</span><span class="gmail-p">,</span>
<span class="gmail-n">reverse_capacity</span> <span class="gmail-n">BIGINT</span><span class="gmail-p">,</span>
<span class="gmail-n">category_id</span> <span class="gmail-n">INTEGER</span><span class="gmail-p">,</span>
<span class="gmail-n">reverse_category_id</span> <span class="gmail-n">INTEGER</span><span class="gmail-p">,</span>
<span class="gmail-n">x1</span> <span class="gmail-n">FLOAT</span><span class="gmail-p">,</span>
<span class="gmail-n">y1</span> <span class="gmail-n">FLOAT</span><span class="gmail-p">,</span>
<span class="gmail-n">x2</span> <span class="gmail-n">FLOAT</span><span class="gmail-p">,</span>
<span class="gmail-n">y2</span> <span class="gmail-n">FLOAT</span><span class="gmail-p">,</span>
<span class="gmail-n">the_geom</span> <span class="gmail-n">geometry</span>
<span class="gmail-p">);</span></pre><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><pre><span class="gmail-n">INSERT</span> <span class="gmail-n">INTO</span> <span class="gmail-n">edge_table</span> <span class="gmail-p">(</span>
<span class="gmail-n">category_id</span><span class="gmail-p">,</span> <span class="gmail-n">reverse_category_id</span><span class="gmail-p">,</span>
<span class="gmail-n">cost</span><span class="gmail-p">,</span> <span class="gmail-n">reverse_cost</span><span class="gmail-p">,</span>
<span class="gmail-n">capacity</span><span class="gmail-p">,</span> <span class="gmail-n">reverse_capacity</span><span class="gmail-p">,</span>
<span class="gmail-n">x1</span><span class="gmail-p">,</span> <span class="gmail-n">y1</span><span class="gmail-p">,</span>
<span class="gmail-n">x2</span><span class="gmail-p">,</span> <span class="gmail-n">y2</span><span class="gmail-p">)</span> <span class="gmail-n">VALUES</span>
<span class="gmail-p">(</span><span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">80</span><span class="gmail-p">,</span> <span class="gmail-mi">130</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">0</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-o">-</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-o">-</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">100</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-o">-</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-o">-</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">130</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">4</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">4</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">100</span><span class="gmail-p">,</span> <span class="gmail-mi">50</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">4</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-o">-</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">130</span><span class="gmail-p">,</span> <span class="gmail-o">-</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">4</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">50</span><span class="gmail-p">,</span> <span class="gmail-mi">100</span><span class="gmail-p">,</span> <span class="gmail-mi">0</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">4</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">50</span><span class="gmail-p">,</span> <span class="gmail-mi">130</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">100</span><span class="gmail-p">,</span> <span class="gmail-mi">130</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">130</span><span class="gmail-p">,</span> <span class="gmail-mi">80</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">4</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">4</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">130</span><span class="gmail-p">,</span> <span class="gmail-mi">50</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-o">-</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">130</span><span class="gmail-p">,</span> <span class="gmail-o">-</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-o">-</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">100</span><span class="gmail-p">,</span> <span class="gmail-o">-</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">4</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-o">-</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">100</span><span class="gmail-p">,</span> <span class="gmail-o">-</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">4</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">80</span><span class="gmail-p">,</span> <span class="gmail-mi">130</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">4</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">4</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">80</span><span class="gmail-p">,</span> <span class="gmail-mi">50</span><span class="gmail-p">,</span> <span class="gmail-mi">4</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">4</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">3</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">80</span><span class="gmail-p">,</span> <span class="gmail-mi">80</span><span class="gmail-p">,</span> <span class="gmail-mi">4</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">4</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">2</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">130</span><span class="gmail-p">,</span> <span class="gmail-mi">100</span><span class="gmail-p">,</span> <span class="gmail-mf">0.5</span><span class="gmail-p">,</span> <span class="gmail-mf">3.5</span><span class="gmail-p">,</span> <span class="gmail-mf">1.999999999999</span><span class="gmail-p">,</span><span class="gmail-mf">3.5</span><span class="gmail-p">),</span>
<span class="gmail-p">(</span><span class="gmail-mi">4</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">1</span><span class="gmail-p">,</span> <span class="gmail-mi">50</span><span class="gmail-p">,</span> <span class="gmail-mi">130</span><span class="gmail-p">,</span> <span class="gmail-mf">3.5</span><span class="gmail-p">,</span> <span class="gmail-mf">2.3</span><span class="gmail-p">,</span> <span class="gmail-mf">3.5</span><span class="gmail-p">,</span><span class="gmail-mi">4</span><span class="gmail-p">);</span>
<span class="gmail-n">UPDATE</span> <span class="gmail-n">edge_table</span> <span class="gmail-n">SET</span> <span class="gmail-n">the_geom</span> <span class="gmail-o">=</span> <span class="gmail-n">st_makeline</span><span class="gmail-p">(</span><span class="gmail-n">st_point</span><span class="gmail-p">(</span><span class="gmail-n">x1</span><span class="gmail-p">,</span><span class="gmail-n">y1</span><span class="gmail-p">),</span><span class="gmail-n">st_point</span><span class="gmail-p">(</span><span class="gmail-n">x2</span><span class="gmail-p">,</span><span class="gmail-n">y2</span><span class="gmail-p">)),</span>
<span class="gmail-nb">dir</span> <span class="gmail-o">=</span> <span class="gmail-n">CASE</span> <span class="gmail-n">WHEN</span> <span class="gmail-p">(</span><span class="gmail-n">cost</span><span class="gmail-o">></span><span class="gmail-mi">0</span> <span class="gmail-n">AND</span> <span class="gmail-n">reverse_cost</span><span class="gmail-o">></span><span class="gmail-mi">0</span><span class="gmail-p">)</span> <span class="gmail-n">THEN</span> <span class="gmail-s1">'B'</span> <span class="gmail-o">--</span> <span class="gmail-n">both</span> <span class="gmail-n">ways</span>
<span class="gmail-n">WHEN</span> <span class="gmail-p">(</span><span class="gmail-n">cost</span><span class="gmail-o">></span><span class="gmail-mi">0</span> <span class="gmail-n">AND</span> <span class="gmail-n">reverse_cost</span><span class="gmail-o"><</span><span class="gmail-mi">0</span><span class="gmail-p">)</span> <span class="gmail-n">THEN</span> <span class="gmail-s1">'FT'</span> <span class="gmail-o">--</span> <span class="gmail-n">direction</span> <span class="gmail-n">of</span> <span class="gmail-n">the</span> <span class="gmail-n">LINESSTRING</span>
<span class="gmail-n">WHEN</span> <span class="gmail-p">(</span><span class="gmail-n">cost</span><span class="gmail-o"><</span><span class="gmail-mi">0</span> <span class="gmail-n">AND</span> <span class="gmail-n">reverse_cost</span><span class="gmail-o">></span><span class="gmail-mi">0</span><span class="gmail-p">)</span> <span class="gmail-n">THEN</span> <span class="gmail-s1">'TF'</span> <span class="gmail-o">--</span> <span class="gmail-n">reverse</span> <span class="gmail-n">direction</span> <span class="gmail-n">of</span> <span class="gmail-n">the</span> <span class="gmail-n">LINESTRING</span>
<span class="gmail-n">ELSE</span> <span class="gmail-s1">''</span> <span class="gmail-n">END</span><span class="gmail-p">;</span> <span class="gmail-o">--</span> <span class="gmail-n">unknown</span></pre><pre><span class="gmail-n">SELECT</span> <span class="gmail-n">pgr_createTopology</span><span class="gmail-p">(</span><span class="gmail-s1">'edge_table'</span><span class="gmail-p">,</span><span class="gmail-mf">0.001</span><span class="gmail-p">);</span>
</pre></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><b>With that data I am getting:</b><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">SELECT * FROM pgr_dijkstra('select id, source, target, cost, reverse_cost FROM edge_table', 1, 15);<br> seq | path_seq | node | edge | cost | agg_cost <br>-----+----------+------+------+------+----------<br>(0 rows)<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">But this image clearly shows there is a path from 1 to 15, what is the problem?</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><img src="cid:ii_jhg8h6ve2_16382b25cbfdc9d4" width="528" height="509"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Please, try to find out what I am doing wrong. (your answer will help see your current level of understanding of pgRouting)</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">and send me data that I can copy/paste into a database so that I can reproduce your problem.<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Regards</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Vicky<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif"><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Sun, May 20, 2018 at 4:43 AM, andy <span dir="ltr"><<a href="mailto:aborruso@gmail.com" target="_blank">aborruso@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="m_7835071795637459499markdown-here-wrapper"><p style="margin:0px 0px 1.2em!important">Hi Vicky,</p><span class="">
<p style="margin:0px 0px 1.2em!important">On Sat, 19 May 2018 at 19:18, Vicky Vergara <a href="http://mailto:vicky@georepublic.de" target="_blank">vicky@georepublic.de</a> wrote:</p>
<p style="margin:0px 0px 1.2em!important"></p><div class="m_7835071795637459499markdown-here-exclude"><p></p><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_extra"><div class="gmail_quote"><div><div>I don't see your data, can you put the contents of the data</div> </div><div><div>The only similar thing as "data" I have is your interpretation of a table contents.</div><div><br></div><div>This is the data:<br></div><div><pre style="font-family:Consolas,Inconsolata,Courier,monospace;font-size:1em;line-height:1.2em;margin:1.2em 0px"><code class="m_7835071795637459499gmail-m_-83730393758385201gmail-m_-7129474597095695591m_-9176503808122599459m_2237830546132782261m_2941265992986126274hljs m_7835071795637459499gmail-m_-83730393758385201gmail-m_-7129474597095695591m_-9176503808122599459m_2237830546132782261m_2941265992986126274language-sql" style="font-size:0.85em;font-family:Consolas,Inconsolata,Courier,monospace;margin:0px 0.15em;white-space:pre-wrap;border:1px solid rgb(204,204,204);background:rgb(248,248,248) none repeat scroll 0% 0%;border-radius:3px;overflow:auto;padding:0.5em;display:block;color:rgb(51,51,51)"><span class="m_7835071795637459499gmail-m_-83730393758385201gmail-m_-7129474597095695591m_-9176503808122599459m_2237830546132782261m_2941265992986126274hljs-operator"><span class="m_7835071795637459499gmail-m_-83730393758385201gmail-m_-7129474597095695591m_-9176503808122599459m_2237830546132782261m_2941265992986126274hljs-string" style="color:rgb(221,17,68)">SELECT ogc_fid as id, source, target, st_length(wkb_geometry)
as "cost" FROM linee;</span></span></code></pre></div></div></div></div></div></blockquote><p></p></div><p style="margin:0px 0px 1.2em!important"></p>
</span><p style="margin:0px 0px 1.2em!important">Here the output (I have added the geom)</p>
<table style="margin:1.2em 0px;padding:0px;border-collapse:collapse;border-spacing:0px;font:inherit;border:0px none">
<thead>
<tr style="border-color:rgb(204,204,204) currentcolor currentcolor;border-style:solid none none;border-width:1px 0px 0px;background-color:white;margin:0px;padding:0px">
<th style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em;font-weight:bold;background-color:rgb(240,240,240)">id</th>
<th style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em;font-weight:bold;background-color:rgb(240,240,240)">source</th>
<th style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em;font-weight:bold;background-color:rgb(240,240,240)">target</th>
<th style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em;font-weight:bold;background-color:rgb(240,240,240)">cost</th>
<th style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em;font-weight:bold;background-color:rgb(240,240,240)">geom</th>
</tr>
</thead>
<tbody style="margin:0px;padding:0px;border:0px none">
<tr style="border-color:rgb(204,204,204) currentcolor currentcolor;border-style:solid none none;border-width:1px 0px 0px;background-color:white;margin:0px;padding:0px">
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">1</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">1</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">2</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">1875.887941</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">SRID=32632;LINESTRING(526471.<wbr>864222973 5083313.32108108,527988.<wbr>654493243 5082209.55351351)</td>
</tr>
<tr style="border-color:rgb(204,204,204) currentcolor currentcolor;border-style:solid none none;border-width:1px 0px 0px;background-color:white;margin:0px;padding:0px;background-color:rgb(248,248,248)">
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">2</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">3</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">1</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">1551.56248159</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">SRID=32632;LINESTRING(525738.<wbr>392871622 5081946.07351351,526471.<wbr>864222973 5083313.32108108)</td>
</tr>
<tr style="border-color:rgb(204,204,204) currentcolor currentcolor;border-style:solid none none;border-width:1px 0px 0px;background-color:white;margin:0px;padding:0px">
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">3</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">1</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">4</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">1506.74402482</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">SRID=32632;LINESTRING(526471.<wbr>864222973 5083313.32108108,527803.<wbr>506385135 5084018.30810811)</td>
</tr>
<tr style="border-color:rgb(204,204,204) currentcolor currentcolor;border-style:solid none none;border-width:1px 0px 0px;background-color:white;margin:0px;padding:0px;background-color:rgb(248,248,248)">
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">4</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">4</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">5</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">1208.08883443</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">SRID=32632;LINESTRING(527803.<wbr>506385135 5084018.30810811,528985.<wbr>605844594 5084267.54594595)</td>
</tr>
<tr style="border-color:rgb(204,204,204) currentcolor currentcolor;border-style:solid none none;border-width:1px 0px 0px;background-color:white;margin:0px;padding:0px">
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">5</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">2</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">6</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">1447.12212188</td>
<td style="font-size:1em;border:1px solid rgb(204,204,204);margin:0px;padding:0.5em 1em">SRID=32632;LINESTRING(527988.<wbr>654493243 5082209.55351351,527020.<wbr>187466217 5081134.27027027)</td>
</tr>
</tbody>
</table>
<p style="margin:0px 0px 1.2em!important">And this is an image generated from this data (my starting point is 1).<br></p><p style="margin:0px 0px 1.2em!important"><img src="cid:ii_jhemvu9i0" alt="immagine.png" style="margin-right:0px"><br><br></p><p style="margin:0px 0px 1.2em!important"><br></p><p style="margin:0px 0px 1.2em!important">Thank you very much</p>
<div title="MDH:PGRpdj5IaSBWaWNreSw8L2Rpdj48ZGl2PjwvZGl2Pjxicj48ZGl2IGNsYXNzPSJnbWFpbF9xdW90
ZSI+PGRpdiBkaXI9Imx0ciI+T24gU2F0LCAxOSBNYXkgMjAxOCBhdCAxOToxOCwgVmlja3kgVmVy
Z2FyYSAmbHQ7dmlja3lAZ2VvcmVwdWJsaWMuZGUmZ3Q7IHdyb3RlOjxicj48L2Rpdj48YmxvY2tx
dW90ZSBjbGFzcz0iZ21haWxfcXVvdGUiIHN0eWxlPSJtYXJnaW46IDBweCAwcHggMHB4IDAuOGV4
OyBib3JkZXItbGVmdDogMXB4IHNvbGlkIHJnYigyMDQsIDIwNCwgMjA0KTsgcGFkZGluZy1sZWZ0
OiAxZXg7Ij48ZGl2IGRpcj0ibHRyIj48ZGl2IHN0eWxlPSJmb250LWZhbWlseTogYXJpYWwsIGhl
bHZldGljYSwgc2Fucy1zZXJpZjsiPjxicj48L2Rpdj48ZGl2IGNsYXNzPSJnbWFpbF9leHRyYSI+
PGRpdiBjbGFzcz0iZ21haWxfcXVvdGUiPjxkaXY+PGRpdj5JIGRvbid0IHNlZSB5b3VyIGRhdGEs
IGNhbiB5b3UgcHV0IHRoZSBjb250ZW50cyBvZiB0aGUgZGF0YeKAizwvZGl2PiZuYnNwOzwvZGl2
PjxkaXY+PGRpdj7igItUaGUgb25seSBzaW1pbGFyIHRoaW5nIGFzICJkYXRhIiBJIGhhdmUgaXMg
eW91ciBpbnRlcnByZXRhdGlvbiBvZiBhIHRhYmxlIGNvbnRlbnRz4oCLLjwvZGl2PjxkaXY+PGJy
PjwvZGl2PjxkaXY+VGhpcyBpcyB0aGUgZGF0YTo8YnI+PC9kaXY+PGRpdj48cHJlIHN0eWxlPSJm
b250LWZhbWlseTogQ29uc29sYXMsIEluY29uc29sYXRhLCBDb3VyaWVyLCBtb25vc3BhY2U7IGZv
bnQtc2l6ZTogMWVtOyBsaW5lLWhlaWdodDogMS4yZW07IG1hcmdpbjogMS4yZW0gMHB4OyI+PGNv
ZGUgY2xhc3M9ImdtYWlsLW1fLTgzNzMwMzkzNzU4Mzg1MjAxZ21haWwtbV8tNzEyOTQ3NDU5NzA5
NTY5NTU5MW1fLTkxNzY1MDM4MDgxMjI1OTk0NTltXzIyMzc4MzA1NDYxMzI3ODIyNjFtXzI5NDEy
NjU5OTI5ODYxMjYyNzRobGpzIGdtYWlsLW1fLTgzNzMwMzkzNzU4Mzg1MjAxZ21haWwtbV8tNzEy
OTQ3NDU5NzA5NTY5NTU5MW1fLTkxNzY1MDM4MDgxMjI1OTk0NTltXzIyMzc4MzA1NDYxMzI3ODIy
NjFtXzI5NDEyNjU5OTI5ODYxMjYyNzRsYW5ndWFnZS1zcWwiIHN0eWxlPSJmb250LXNpemU6IDAu
ODVlbTsgZm9udC1mYW1pbHk6IENvbnNvbGFzLCBJbmNvbnNvbGF0YSwgQ291cmllciwgbW9ub3Nw
YWNlOyBtYXJnaW46IDBweCAwLjE1ZW07IHdoaXRlLXNwYWNlOiBwcmUtd3JhcDsgYm9yZGVyOiAx
cHggc29saWQgcmdiKDIwNCwgMjA0LCAyMDQpOyBiYWNrZ3JvdW5kOiByZ2IoMjQ4LCAyNDgsIDI0
OCkgbm9uZSByZXBlYXQgc2Nyb2xsIDAlIDAlOyBib3JkZXItcmFkaXVzOiAzcHg7IG92ZXJmbG93
OiBhdXRvOyBwYWRkaW5nOiAwLjVlbTsgZGlzcGxheTogYmxvY2s7IGNvbG9yOiByZ2IoNTEsIDUx
LCA1MSk7Ij48c3BhbiBjbGFzcz0iZ21haWwtbV8tODM3MzAzOTM3NTgzODUyMDFnbWFpbC1tXy03
MTI5NDc0NTk3MDk1Njk1NTkxbV8tOTE3NjUwMzgwODEyMjU5OTQ1OW1fMjIzNzgzMDU0NjEzMjc4
MjI2MW1fMjk0MTI2NTk5Mjk4NjEyNjI3NGhsanMtb3BlcmF0b3IiPjxzcGFuIGNsYXNzPSJnbWFp
bC1tXy04MzczMDM5Mzc1ODM4NTIwMWdtYWlsLW1fLTcxMjk0NzQ1OTcwOTU2OTU1OTFtXy05MTc2
NTAzODA4MTIyNTk5NDU5bV8yMjM3ODMwNTQ2MTMyNzgyMjYxbV8yOTQxMjY1OTkyOTg2MTI2Mjc0
aGxqcy1zdHJpbmciIHN0eWxlPSJjb2xvcjogcmdiKDIyMSwgMTcsIDY4KTsiPlNFTEVDVCBvZ2Nf
ZmlkIGFzIGlkLCBzb3VyY2UsIHRhcmdldCwgc3RfbGVuZ3RoKHdrYl9nZW9tZXRyeSkgCiAgICAg
ICAgICAgICAgICAgICAgICAgICAgIGFzICJjb3N0IiBGUk9NIGxpbmVlOzwvc3Bhbj48L3NwYW4+
PC9jb2RlPjwvcHJlPjwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2PjwvZGl2PjwvYmxvY2txdW90ZT48
ZGl2PkhlcmUgdGhlIG91dHB1dCAoSSBoYXZlIGFkZGVkIHRoZSBnZW9tKTxicj48L2Rpdj48ZGl2
Pjxicj48L2Rpdj48ZGl2PnwgaWQmbmJzcDsgfCBzb3VyY2UmbmJzcDsgfCB0YXJnZXQmbmJzcDsg
fCBjb3N0Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i
c3A7Jm5ic3A7IHwgZ2VvbSZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw
OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu
YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw
OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu
YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw
OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu
YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw
OyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZu
YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw
OyZuYnNwOyZuYnNwOyZuYnNwOyB8IDxicj58LS0tLS18LS0tLS0tLS0tfC0tLS0tLS0tLXwtLS0t
LS0tLS0tLS0tLS0tfC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tfCA8YnI+fCAx
Jm5ic3A7Jm5ic3A7IHwgMSZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyB8IDIm
bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgfCAxODc1Ljg4Nzk0MSZuYnNwOyZu
YnNwOyZuYnNwOyB8IFNSSUQ9MzI2MzI7TElORVNUUklORyg1MjY0NzEuODY0MjIyOTczIDUwODMz
MTMuMzIxMDgxMDgsNTI3OTg4LjY1NDQ5MzI0MyA1MDgyMjA5LjU1MzUxMzUxKSB8IDxicj58IDIm
bmJzcDsmbmJzcDsgfCAzJm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IHwgMSZu
YnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyB8IDE1NTEuNTYyNDgxNTkmbmJzcDsg
fCBTUklEPTMyNjMyO0xJTkVTVFJJTkcoNTI1NzM4LjM5Mjg3MTYyMiA1MDgxOTQ2LjA3MzUxMzUx
LDUyNjQ3MS44NjQyMjI5NzMgNTA4MzMxMy4zMjEwODEwOCkgfCA8YnI+fCAzJm5ic3A7Jm5ic3A7
IHwgMSZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyB8IDQmbmJzcDsmbmJzcDsm
bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgfCAxNTA2Ljc0NDAyNDgyJm5ic3A7IHwgU1JJRD0zMjYz
MjtMSU5FU1RSSU5HKDUyNjQ3MS44NjQyMjI5NzMgNTA4MzMxMy4zMjEwODEwOCw1Mjc4MDMuNTA2
Mzg1MTM1IDUwODQwMTguMzA4MTA4MTEpIHwgPGJyPnwgNCZuYnNwOyZuYnNwOyB8IDQmbmJzcDsm
bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgfCA1Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7
Jm5ic3A7Jm5ic3A7IHwgMTIwOC4wODg4MzQ0MyZuYnNwOyB8IFNSSUQ9MzI2MzI7TElORVNUUklO
Ryg1Mjc4MDMuNTA2Mzg1MTM1IDUwODQwMTguMzA4MTA4MTEsNTI4OTg1LjYwNTg0NDU5NCA1MDg0
MjY3LjU0NTk0NTk1KSB8IDxicj58IDUmbmJzcDsmbmJzcDsgfCAyJm5ic3A7Jm5ic3A7Jm5ic3A7
Jm5ic3A7Jm5ic3A7Jm5ic3A7IHwgNiZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNwOyZuYnNw
OyB8IDE0NDcuMTIyMTIxODgmbmJzcDsgfCBTUklEPTMyNjMyO0xJTkVTVFJJTkcoNTI3OTg4LjY1
NDQ5MzI0MyA1MDgyMjA5LjU1MzUxMzUxLDUyNzAyMC4xODc0NjYyMTcgNTA4MTEzNC4yNzAyNzAy
NykgfCA8YnI+PGJyPjwvZGl2PjxkaXY+VGhhbmsgeW91IHZlcnkgbXVjaDwvZGl2PjwvZGl2Pjxi
ciBjbGVhcj0iYWxsIj48YnI+" style="height:0;width:0;max-height:0;max-width:0;overflow:hidden;font-size:0em;padding:0;margin:0"></div></div><span class="">-- <br><div dir="ltr" class="m_7835071795637459499gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><span style="font-size:small">___________________</span><br></div><div dir="ltr"><span style="font-size:small"><br></span></div><div dir="ltr">Andrea Borruso<br>
website: <a href="https://medium.com/tantotanto" target="_blank">https://medium.com/tantotanto</a><br>38° 7' 48" N, 13° 21' 9" E, EPSG:4326<br><span style="font-size:small">___________________</span><br>
<br>
"cercare e saper riconoscere chi e cosa,<br>
in mezzo all’inferno, non è inferno, <br>
e farlo durare, e dargli spazio"<br>
<br>
Italo Calvino<br></div></div></div></div></div></div></div></div></div></div></div></div></div></span></div>
<br>______________________________<wbr>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.<wbr>org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/<wbr>mailman/listinfo/pgrouting-<wbr>users</a><br></blockquote></div><br><br clear="all"><br>-- <br><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><pre>Georepublic UG (haftungsbeschränkt)
Salzmannstraße 44,
81739 München, Germany
Vicky Vergara
Operations Research
eMail: vicky@<a href="http://georepublic.de" target="_blank">georepublic.de</a>
Web: <a href="https://georepublic.info" target="_blank">https://georepublic.info</a>
Tel: +49 (089) 4161 7698-1
Fax: +49 (089) 4161 7698-9
Commercial register: Amtsgericht München, HRB 181428
CEO: Daniel Kastl
<span></span></pre></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div>
</div>