List of functions and output column names

[cvvergara]

functions	output_columns
pgr_bridges pgr_maxcardinalitymatch	{edge}
pgr_edgecoloring	{edge,color}
pgr_kruskal pgr_prim	{edge,cost}
pgr_findcloseedges	{edge_id,fraction,side,distance,geom,edge}
pgr_extractvertices	{id,in_edges,out_edges,x,y,geom}
pgr_articulationpoints	{node}
pgr_bipartite pgr_sequentialvertexcoloring	{node,color}
pgr_degree	{node,degree}
pgr_transitiveclosure	{node,targets}
pgr_vrponedepot	{oid,opos,vid,tarrival,tdepart}
pgr_biconnectedcomponents	{seq,component,edge}
pgr_connectedcomponents pgr_strongcomponents	{seq,component,node}
pgr_breadthfirstsearch pgr_depthfirstsearch pgr_drivingdistance pgr_kruskalbfs pgr_kruskaldd pgr_kruskaldfs pgr_primbfs pgr_primdd pgr_primdfs pgr_withpointsdd	{seq,depth,start_vid,pred,node,edge,cost,agg_cost}
pgr_stoerwagner	{seq,edge,cost,mincut}
pgr_maxflowmincost	{seq,edge,source,target,flow,residual_capacity,cost,agg_cost}
pgr_boykovkolmogorov pgr_edmondskarp pgr_pushrelabel	{seq,edge,start_vid,end_vid,flow,residual_capacity}
pgr_separatecrossing pgr_separatetouching	{seq,id,sub_id,geom}
pgr_cuthillmckeeordering pgr_topologicalsort	{seq,node}
pgr_tsp pgr_tspeuclidean	{seq,node,cost,agg_cost}
pgr_chinesepostman	{seq,node,edge,cost,agg_cost}
pgr_edgedisjointpaths pgr_hawickcircuits pgr_ksp pgr_turnrestrictedpath pgr_withpointsksp	{seq,path_id,path_seq,start_vid,end_vid,node,edge,cost,agg_cost}
pgr_dijkstravia pgr_trspvia pgr_trspvia_withpoints pgr_withpointsvia	{seq,path_id,path_seq,start_vid,end_vid,node,edge,cost,agg_cost,route_agg_cost}
pgr_astar pgr_bdastar pgr_bddijkstra pgr_bellmanford pgr_binarybreadthfirstsearch pgr_dagshortestpath pgr_dijkstra pgr_dijkstranear pgr_edwardmoore pgr_trsp pgr_trsp_withpoints pgr_withpoints	{seq,path_seq,start_vid,end_vid,node,edge,cost,agg_cost}
pgr_linegraphfull	{seq,source,target,cost,edge}
pgr_linegraph	{seq,source,target,cost,reverse_cost}
pgr_makeconnected	{seq,start_vid,end_vid}
pgr_pickdelivereuclidean	{seq,vehicle_seq,vehicle_id,stop_seq,stop_type,order_id,cargo,travel_time,arrival_time,wait_time,service_time,departure_time}
pgr_pickdeliver	{seq,vehicle_seq,vehicle_id,stop_seq,stop_type,stop_id,order_id,cargo,travel_time,arrival_time,wait_time,service_time,departure_time}
pgr_lengauertarjandominatortree	{seq,vertex_id,idom}
pgr_astarcost pgr_astarcostmatrix pgr_bdastarcost pgr_bdastarcostmatrix pgr_bddijkstracost pgr_bddijkstracostmatrix pgr_dijkstracost pgr_dijkstracostmatrix pgr_dijkstranearcost pgr_floydwarshall pgr_johnson pgr_withpointscost pgr_withpointscostmatrix	{start_vid,end_vid,agg_cost}
pgr_contraction pgr_contractiondeadend pgr_contractionlinear	{type,id,contracted_vertices,source,target,cost}
pgr_contractionhierarchies	{type,id,contracted_vertices,source,target,cost,metric,vertex_order}
pgr_full_version	{version,build_type,compile_date,library,system,postgresql,compiler,boost,hash}
pgr_betweennesscentrality	{vid,centrality}
pgr_chinesepostmancost pgr_isplanar pgr_maxflow pgr_maxflowmincost_cost pgr_version	{}

 WITH 
columns AS (
  SELECT DISTINCT proargnames[pronargs+1:] AS results, proname 
  FROM pg_catalog.pg_proc where proname ilike 'pgr_%'),
data AS (
  SELECT results, array_agg(proname ORDER BY proname) fname 
  FROM columns GROUP BY results ORDER BY fname)
SELECT array_to_string(fname, ' <br> ') as functions, results AS output_columns 
FROM data ORDER BY output_columns;

[cvvergara]

Functions that need output column standardization

count	functiom
4	pgr_bddijkstra
4	pgr_bellmanford
4	pgr_binarybreadthfirstsearch
4	pgr_edgedisjointpaths
4	pgr_edwardmoore

PR opened in pgRouting#2904

WITH 
columns AS (
  SELECT DISTINCT coalesce(proargnames[pronargs+1:],'{}') AS results, proname 
  FROM pg_catalog.pg_proc where proname ilike 'pgr_%')
SELECT count(results), proname 
FROM columns GROUP BY proname ORDER BY count, proname;

[robe2]

Let me know when you have the following structures stabilized for 4.0:

functions	output_columns
pgr_bridges pgr_maxcardinalitymatch	{edge}
pgr_findcloseedges	{edge_id,fraction,side,distance,geom,edge}
pgr_extractvertices	{id,in_edges,out_edges,x,y,geom}
pgr_articulationpoints	{node}
pgr_degree	{node,degree}
pgr_vrponedepot	{oid,opos,vid,tarrival,tdepart}
pgr_biconnectedcomponents	{seq,component,edge}
pgr_connectedcomponents pgr_strongcomponents	{seq,component,node}
pgr_drivingdistance pgr_withpointsdd	{seq,depth,start_vid,pred,node,edge,cost,agg_cost}
pgr_tsp pgr_tspeuclidean	{seq,node,cost,agg_cost}
pgr_chinesepostman	{seq,node,edge,cost,agg_cost}
pgr_dijkstravia pgr_trspvia pgr_trspvia_withpoints pgr_withpointsvia	{seq,path_id,path_seq,start_vid,end_vid,node,edge,cost,agg_cost,route_agg_cost}
pgr_makeconnected	{seq,start_vid,end_vid}
pgr_pickdelivereuclidean	{seq,vehicle_seq,vehicle_id,stop_seq,stop_type,order_id,cargo,travel_time,arrival_time,wait_time,service_time,departure_time}
pgr_pickdeliver	{seq,vehicle_seq,vehicle_id,stop_seq,stop_type,stop_id,order_id,cargo,travel_time,arrival_time,wait_time,service_time,departure_time}
pgr_contraction pgr_contractiondeadend pgr_contractionlinear	{type,id,contracted_vertices,source,target,cost}
pgr_contractionhierarchies	{type,id,contracted_vertices,source,target,cost,metric,vertex_order}
pgr_full_version	{version,build_type,compile_date,library,system,postgresql,compiler,boost,hash}
pgr_version
pgr_astarcost pgr_astarcostmatrix pgr_dijkstracost pgr_dijkstracostmatrix pgr_withpointscost pgr_withpointscostmatrix	{start_vid,end_vid,agg_cost}