[mrt] sql file signature added

prakashupes · cvvergara · commit 2d91b602b543 · 2020-08-24T09:51:59.000-05:00
diff --git a/sql/spanningTree/_mrt.sql b/sql/spanningTree/_mrt.sql
@@ -28,4 +28,24 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
  ********************************************************************PGR-GNU*/
 ---------------
 -- _pgr_mrt
----------------
+---------------
+
+CREATE OR REPLACE FUNCTION _pgr_LTDTree(
+    edges_sql1 TEXT, -- edges_sql1 (required)
+    edges_sql2 TEXT, -- edges_sql2 (required)
+    directed BOOLEAN DEFAULT true,
+
+    OUT seq integer,
+    OUT tree_edges BIGINT[] --contains list of edegs of spanning tree
+   )
+
+RETURNS SETOF RECORD AS
+'MODULE_PATHNAME'
+LANGUAGE c VOLATILE STRICT;
+
+-- COMMENTS
+
+
+COMMENT ON FUNCTION _pgr_mrt(TEXT,TEXT,BOOLEAN)
+IS 'pgRouting internal function';
+
diff --git a/sql/spanningTree/mrt.sql b/sql/spanningTree/mrt.sql
@@ -28,4 +28,37 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
  ********************************************************************PGR-GNU*/
 ---------------
 -- pgr_mrt
----------------
+---------------
+CREATE OR REPLACE FUNCTION pgr_LTDTree(
+    edges_sql1 TEXT, -- edges_sql1 (required)
+    edges_sql2 TEXT, -- edges_sql2 (required)
+    directed BOOLEAN DEFAULT true,
+
+    OUT seq integer,
+    OUT tree_edges BIGINT[] --contains list of edegs of spanning tree
+    )
+RETURNS SETOF RECORD AS
+$BODY$
+BEGIN
+
+    RETURN QUERY
+    SELECT *
+    FROM _pgr_mrt(_pgr_get_statement($1),_pgr_get_statement($2),$3);
+END;
+$BODY$
+LANGUAGE  plpgsql VOLATILE STRICT;
+
+
+-- COMMENTS
+
+
+COMMENT ON FUNCTION pgr_mrt(TEXT,TEXT,BOOLEAN)
+IS 'pgr_mrt
+- EXPERIMENTAL
+- Directed graph
+- Parameters:
+  - edges SQL with columns: id, source, target, cost [,reverse_cost]
+- Documentation:
+  - ${PGROUTING_DOC_LINK}/pgr_LTDTree.html
+';
+
