<HTML><BODY>Hi again.<br><br>As written in the <a href="http://docs.pgrouting.org/2.0/en/src/trsp/doc/index.html#trsp" data-mce-href="http://docs.pgrouting.org/2.0/en/src/trsp/doc/index.html#trsp">documentation </a>for SQL statement of TRSP:<br>id: int4 identifier of the edge<br><br>But pgr_createTopology function creates new "noded" table with "id" of bigint type.<br><br>I've solved this problem by casting "id" to integer type.<br><br>Now that's works:<br>SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_trsp('SELECT id::integer,source::integer,target::integer,cost::float FROM edge_tab', 138, 0.5, 161, 0.5, false, false);<br><br>Thanks very much to author of <a href="http://pgrouting-users.974093.n3.nabble.com/pgrouting-users-Shortest-Path-TRSP-td3782221.html" data-mce-href="http://pgrouting-users.974093.n3.nabble.com/pgrouting-users-Shortest-Path-TRSP-td3782221.html">this</a> post for idea.<br><br>Best regards.<br><br><br>
<blockquote style="border-left:1px solid #0857A6; margin:10px; padding:0 0 0 10px;">
<div id="">
<div class="js-helper js-readmsg-msg">
<style type="text/css"></style>
<div id="style_13941323320000000458" class="mr_read__body">
<base target="_self" href="https://e.mail.ru/">
<div id="style_13941323320000000458_BODY">
<p>Hello All!<br><br>I try to use TRSP with source_edge/target_edge syntax:<br></p><p>SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_trsp('SELECT id,source::integer,target::integer,cost::float FROM edge_tab', 138, 0.5, 161, 0.5, false, false);<br><br>but the error "Start id was not found" occurs.<br></p><p>Edges with ids 138 and 161 exists in edge_tab that's checked by <br>SELECT * FROM edge_tab WHERE id in (138,161)<br><br>pgr_version: 2.0.0,pgrouting-2.0.0,0,f26831f,master,1.53.0<br><br>Please could you tell me what's wrong ?<br></p><br><br>
</div>
<div>_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="/compose?To=Pgrouting%2dusers@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
</div>
<base target="_self" href="https://e.mail.ru/">
</div>
</div>
</div>
</blockquote>
<br>
<br></BODY></HTML>