I'm trying to find a shortest path between 2 nodes using djikstra method but it keeps saying
ERROR: Error, query must return columns 'id', 'source', 'target' and 'cost'
this is my query:
SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_dijkstra('SELECT gid, source,target, ST_Length(geom2d) as cost FROM public.canada_rail_net', 1, 200, false, false);
is there anything wrong with column names?