[pgrouting-users] (SOLVED) TRSP returns "Start id was not found"

[Vladimir]

 Hi again.

As written in the  documentation  for SQL statement of TRSP:
id:    int4 identifier of the edge

But  pgr_createTopology function creates new "noded" table with "id" of bigint type.

I've solved this problem by casting "id" to integer type.

Now that's works:
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);

Thanks very much to author of  this post for idea.

Best regards.


>Hello All!
>
>I try to use TRSP with source_edge/target_edge syntax:
>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);
>
>but the error "Start id was not found" occurs.
>Edges with ids 138 and 161 exists in edge_tab that's checked by  
>SELECT * FROM edge_tab WHERE id in (138,161)
>
>pgr_version: 2.0.0,pgrouting-2.0.0,0,f26831f,master,1.53.0
>
>Please could you tell me what's wrong ?
>
>
>_______________________________________________
>Pgrouting-users mailing list
>Pgrouting-users at lists.osgeo.org
>http://lists.osgeo.org/mailman/listinfo/pgrouting-users


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20140307/1aa8cf4d/attachment.html>