<div dir="ltr"><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">Hello,</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">Yes, there is a reason, all the edges have the same cost in the sample graph, so there might be more than one path from one vertex to another with the same min cost.<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">To get the same result on this examples ORDER BY keeps always the input in the same order, so it will give the results in the same order.</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">All the documentation queries/results are generated automatically, but different OS can give different results because the internal storage, we test those queries on three different OS, and sometimes without the ORDER BY, form one to another the results are different.</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">going from v5 to v11 can be done as follows</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">(Possible answer on OS foo)<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">v5 -> v10 -> v11 with cost 2<br></div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">or as follows</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">(Possible answer on OS bar)</div><div class="gmail_default" style="font-family:arial,helvetica,sans-serif">v5 -> v6 -> v11 with cost 2<br></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"></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 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 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 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 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 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 Sat, Sep 30, 2017 at 6:27 AM, Jakob Miksch <span dir="ltr"><<a href="mailto:jakob.miksch@posteo.eu" target="_blank">jakob.miksch@posteo.eu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Dear List,<br>
<br>
I compare the arguments of "pgr_drivingDistance"[1] and "pgr_withPointsDD"[2].<br>
<br>
The example of "pgr_withPointsDD"[2] confuses me. In the examples the argument "edges_sql" ends with "ORDER BY id". Whereas "pgr_drivingDistance"[1] does not.<br>
<br>
Is there any reason for the "ORDER BY id" in the "pgr_withPointsDD"[2] function?<br>
(see examples below)<br>
<br>
Best regards,<br>
Jakob<br>
<br>
[1] <a href="http://docs.pgrouting.org/latest/en/pgr_drivingDistance.html" rel="noreferrer" target="_blank">http://docs.pgrouting.org/late<wbr>st/en/pgr_drivingDistance.html</a><br>
[2] <a href="http://docs.pgrouting.org/latest/en/pgr_withPointsDD.html" rel="noreferrer" target="_blank">http://docs.pgrouting.org/late<wbr>st/en/pgr_withPointsDD.html</a><br>
<br>
Examples:<br>
<br>
SELECT * FROM pgr_drivingDistance(<br>
'SELECT id, source, target, cost, reverse_cost FROM edge_table',<br>
2, 3<br>
);<br>
<br>
<br>
SELECT * FROM pgr_withPointsDD(<br>
'SELECT id, source, target, cost, reverse_cost FROM edge_table ORDER BY id',<br>
'SELECT pid, edge_id, fraction, side from pointsOfInterest',<br>
-1, 3.8,<br>
driving_side := 'l',<br>
details := true);<br>
______________________________<wbr>_________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.or<wbr>g</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailma<wbr>n/listinfo/pgrouting-users</a></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>