pgrouting/sql/costMatrix/dijkstraCostMatrix.sql at master · gisdevelope/pgrouting · GitHub

48 lines (34 loc) · 1.48 KB

/*PGR-GNU*****************************************************************

Mail: project@pgrouting.org

mail: vicky_vergara@hotmail.com

------

This program is free software; you can redistribute it and/or modify

it under the terms of the GNU General Public License as published by

the Free Software Foundation; either version 2 of the License, or

(at your option) any later version.

This program is distributed in the hope that it will be useful,

but WITHOUT ANY WARRANTY; without even the implied warranty of

MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the

GNU General Public License for more details.

You should have received a copy of the GNU General Public License

along with this program; if not, write to the Free Software

Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.

********************************************************************PGR-GNU*/

-- DIJKSTRA DMatrix

/***********************************

MANY TO MANY

***********************************/

CREATE OR REPLACE FUNCTION pgr_dijkstraCostMatrix(edges_sql TEXT, vids ANYARRAY, directed BOOLEAN DEFAULT true,

OUT start_vid BIGINT, OUT end_vid BIGINT, OUT agg_cost float)

RETURNS SETOF RECORD AS

$BODY$

BEGIN

RETURN query SELECT a.start_vid, a.end_vid, a.agg_cost

FROM _pgr_dijkstra(_pgr_get_statement($1), $2, $2, $3, true) a;

END

$BODY$

LANGUAGE plpgsql VOLATILE

COST 100

ROWS 1000;

Expand file tree