[pgrouting-users] shortest path query

[Annu Anurag]

Yes! It was the reference. I changed the query to:

DATA "the_geom FROM (SELECT (SELECT the_geom FROM edges_line), b.* FROM
(SELECT * FROM shortest_path('SELECT gid AS id, fromnodeid::int4 AS source,
tonodeid::int4 AS target, length0::float8 AS cost FROM edges_line', 35,
210, false, false)) AS a, edges_line AS b WHERE a.edge_id = b.gid) AS foo
using unique gid using srid=4326"


and it worked! Thank you so much for your time and effort sir!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20120613/b3a87935/attachment.html>