All pastes #911799 Raw Edit

Stuff

public text v1 · immutable
·published 2008-02-20 22:45 UTC
rendered paste body
CREATE OR REPLACE FUNCTION a_calculateshortestpath_retepd(startpoint integer, endpoint integer, avoid_ztl boolean, main_routing boolean, sessionid text)
  RETURNS SETOF resultsgeo_retepd AS
$BODY$

[CUT]

INSERT into results_retepd 
select * FROM 
shortest_path_astar ('SELECT gid AS id, source::int4, target::int4, length::double precision AS cost, 
length::double precision AS reverse_cost,x1,x2,y1,y2 FROM a_getpadova('||avoidztl_str||','||main_routing_str||') '
, p_start, p_end, false, false), sessionid as sessionid;

[CUT]
END;