[pgrouting-users] shortest path query

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!