[pgrouting-users] Fixed sequence routing.

[Andrea Nardelli]

Hello,
you can just do a JOIN on the edge id between the Dijkstra result and the
edge table:

SELECT seq, path_seq, node, edge, d.cost, agg_cost, the_geomFROM
(SELECT * FROM pgr_dijkstra(
      'SELECT id, source, target, cost, reverse_cost FROM edge_table',
      2, 3
  )) as d, edge_tableWHERE d.edge=edge_table.id

~Andrea



2016-03-08 15:59 GMT+01:00 Omar Fernando Pessôa <omar.pessoa at gmail.com>:

> Hi guys, sorry about question...
>
> Does have some of pgrouting functions thats returns linestring dijkstra
> from sequenced nodes?
>
> for all itens on sequency
>   accum linestring from dijkstra item, item+1
>
>
> Thanks.
> ..
> *Omar Fernando Pessôa*
> http://www.opessoa.info
> Desenvolvedor de sistemas
> Programador C++
>
> _______________________________________________
> 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/20160308/a7b0bc82/attachment.html>