<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:12pt"><div>Dear pgrouting users,</div><div>I am begginer at using pgrouting and SQL as a whole, but this tool would be very useful for my projects. My task is to perform traffic assignment on the road network of Bulgaria. I use routable map prepared with Osm2po. My start/end points are defined according to the map nodes. Using the code from the example:</div><div><br></div><pre style="overflow-x: auto; overflow-y: hidden; padding: 5px; background-color: rgb(238, 255, 204); color: rgb(51, 51, 51); line-height: 15.600000381469727px; border-top-width: 1px; border-bottom-width: 1px; border-style: solid none; border-top-color: rgb(170, 204, 153); border-bottom-color: rgb(170, 204, 153);"><span class="k" style="color: rgb(0, 112, 32); font-weight: bold;">SELECT</span> <span class="n">seq</span><span
class="p">,</span> <span class="n">id1</span> <span class="k" style="color: rgb(0, 112, 32); font-weight: bold;">AS</span> <span class="n">node</span><span class="p">,</span> <span class="n">id2</span> <span class="k" style="color: rgb(0, 112, 32); font-weight: bold;">AS</span> <span class="n">edge</span><span class="p">,</span> <span class="n">cost</span> <span class="k" style="color: rgb(0, 112, 32); font-weight: bold;">FROM</span> <span class="n">pgr_dijkstra</span><span class="p">(</span><span class="s1" style="color: rgb(64, 112, 160);">'</span>
<span class="s1" style="color: rgb(64, 112, 160);"> SELECT gid AS id,</span>
<span class="s1" style="color: rgb(64, 112, 160);"> source::integer,</span>
<span class="s1" style="color: rgb(64, 112, 160);"> target::integer,</span>
<span class="s1" style="color: rgb(64, 112, 160);"> length::double precision AS cost</span>
<span class="s1" style="color: rgb(64, 112, 160);"> FROM ways'</span><span class="p">,</span>
<span class="mi" style="color: rgb(32, 128, 80);">30</span><span class="p">,</span> <span class="mi" style="color: rgb(32, 128, 80);">60</span><span class="p">,</span> <span class="k" style="color: rgb(0, 112, 32); font-weight: bold;">false</span><span class="p">,</span> <span class="k" style="color: rgb(0, 112, 32); font-weight: bold;">false</span><span class="p">);</span></pre></div></body></html>