pgRoutingDocs/processing/database

This page needs some review!

JOIN two tables

SELECT 
	count(gid) AS links, 
	sum(a.cost) AS cost, 
	sum(length) AS length

FROM shortest_path(
	'SELECT gid AS id, 
		source::integer, 
		target::integer, 
		length::double precision AS cost 
	FROM <TABLE A> 
	WHERE <...>, 
	false, 
	false
) AS a LEFT JOIN <TABLE B> ON (a.gid = gid)