SELECT lp1.route_id, st_makeline(lp1.node, lp2.node) as line FROM list_points as lp1,
list_points as lp2 WHERE lp2.path_index - lp1.path_index = 1 AND lp1.route_id = lp2.route_id;