Code: Select all
SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_dijkstra('
SELECT gid AS id,
source::integer,
target::integer,
length * c.cost AS cost
FROM ways, classes c
WHERE class_id = c.id',
30, 60, false, false);
Code: Select all
length * c.cost AS cost
FROM ways, classes c
WHERE class_id = c.id',