Skip to content

Commit f08b768

Browse files
cvvergaracvvergara
committed
(withPoints) Adding functions without driving side
1 parent 80d70b4 commit f08b768

9 files changed

Lines changed: 1109 additions & 20 deletions

File tree

‎sql/driving_distance/withPointsDD.sql‎

Lines changed: 95 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -53,7 +53,8 @@ CREATE FUNCTION pgr_withPointsDD(
5353
RETURNS SETOF RECORD AS
5454
$BODY$
5555
SELECT seq, depth, start_vid, pred, node, edge, cost, agg_cost
56-
FROM _pgr_withPointsDDv4(_pgr_get_statement($1), _pgr_get_statement($2), ARRAY[$3]::BIGINT[], $4, $5, $6, $7, false);
56+
FROM _pgr_withPointsDDv4(_pgr_get_statement($1), _pgr_get_statement($2), ARRAY[$3]::BIGINT[], $4,
57+
$5, directed, details, false);
5758
$BODY$
5859
LANGUAGE SQL VOLATILE STRICT
5960
COST ${COST_HIGH} ROWS ${ROWS_HIGH};
@@ -82,7 +83,8 @@ CREATE FUNCTION pgr_withPointsDD(
8283
RETURNS SETOF RECORD AS
8384
$BODY$
8485
SELECT seq, depth, start_vid, pred, node, edge, cost, agg_cost
85-
FROM _pgr_withPointsDDv4(_pgr_get_statement($1), _pgr_get_statement($2), $3, $4, $5, $6, $7, $8);
86+
FROM _pgr_withPointsDDv4(_pgr_get_statement($1), _pgr_get_statement($2), $3, $4,
87+
$5, directed, details, equicost);
8688
$BODY$
8789
LANGUAGE SQL VOLATILE STRICT
8890
COST ${COST_HIGH} ROWS ${ROWS_HIGH};
@@ -95,7 +97,7 @@ IS 'pgr_withPointsDD(Single Vertex)
9597
- Points SQL with columns: [pid], edge_id, fraction[,side]
9698
- From vertex identifier
9799
- Distance
98-
- Driving_side
100+
- Driving side
99101
- Optional Parameters
100102
- directed := true
101103
- details := false
@@ -111,7 +113,96 @@ IS 'pgr_withPointsDD(Multiple Vertices)
111113
- Points SQL with columns: [pid], edge_id, fraction[,side]
112114
- From ARRAY[vertices identifiers]
113115
- Distance
114-
- Driving_side
116+
- Driving side
117+
- Optional Parameters
118+
- directed := true
119+
- details := false
120+
- equicost := false
121+
- Documentation:
122+
- ${PROJECT_DOC_LINK}/pgr_withPointsDD.html
123+
';
124+
125+
126+
-- SINGLE
127+
--v4.0
128+
CREATE FUNCTION pgr_withPointsDD(
129+
TEXT, --edges_sql (required)
130+
TEXT, -- points_sql (required)
131+
BIGINT, -- from_vid (required)
132+
FLOAT, -- distance (required)
133+
134+
directed BOOLEAN DEFAULT true,
135+
details BOOLEAN DEFAULT false,
136+
137+
OUT seq BIGINT,
138+
OUT depth BIGINT,
139+
OUT start_vid BIGINT,
140+
OUT pred BIGINT,
141+
OUT node BIGINT,
142+
OUT edge BIGINT,
143+
OUT cost FLOAT,
144+
OUT agg_cost FLOAT)
145+
RETURNS SETOF RECORD AS
146+
$BODY$
147+
SELECT seq, depth, start_vid, pred, node, edge, cost, agg_cost
148+
FROM _pgr_withPointsDDv4(_pgr_get_statement($1), _pgr_get_statement($2), ARRAY[$3]::BIGINT[], $4,
149+
(CASE WHEN directed THEN 'r' ELSE 'b' END), directed, details, false);
150+
$BODY$
151+
LANGUAGE SQL VOLATILE STRICT
152+
COST ${COST_HIGH} ROWS ${ROWS_HIGH};
153+
154+
-- MULTIPLE
155+
--v4.0
156+
CREATE FUNCTION pgr_withPointsDD(
157+
TEXT, --edges_sql (required)
158+
TEXT, -- points_sql (required)
159+
ANYARRAY, -- from_vid (required)
160+
FLOAT, -- distance (required)
161+
162+
directed BOOLEAN DEFAULT true,
163+
details BOOLEAN DEFAULT false,
164+
equicost BOOLEAN DEFAULT false,
165+
166+
OUT seq BIGINT,
167+
OUT depth BIGINT,
168+
OUT start_vid BIGINT,
169+
OUT pred BIGINT,
170+
OUT node BIGINT,
171+
OUT edge BIGINT,
172+
OUT cost FLOAT,
173+
OUT agg_cost FLOAT)
174+
RETURNS SETOF RECORD AS
175+
$BODY$
176+
SELECT seq, depth, start_vid, pred, node, edge, cost, agg_cost
177+
FROM _pgr_withPointsDDv4(_pgr_get_statement($1), _pgr_get_statement($2), $3, $4,
178+
(CASE WHEN directed THEN 'r' ELSE 'b' END), directed, details, equicost);
179+
$BODY$
180+
LANGUAGE SQL VOLATILE STRICT
181+
COST ${COST_HIGH} ROWS ${ROWS_HIGH};
182+
183+
184+
COMMENT ON FUNCTION pgr_withPointsDD(TEXT, TEXT, BIGINT, FLOAT, BOOLEAN, BOOLEAN)
185+
IS 'pgr_withPointsDD(Single Vertex)
186+
- Parameters:
187+
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
188+
- Points SQL with columns: [pid], edge_id, fraction[,side]
189+
- From vertex identifier
190+
- Distance
191+
- Optional Parameters
192+
- directed := true
193+
- details := false
194+
- Documentation:
195+
- ${PROJECT_DOC_LINK}/pgr_withPointsDD.html
196+
';
197+
198+
199+
COMMENT ON FUNCTION pgr_withPointsDD(TEXT, TEXT, ANYARRAY, FLOAT, BOOLEAN, BOOLEAN, BOOLEAN)
200+
IS 'pgr_withPointsDD(Multiple Vertices)
201+
- Parameters:
202+
- Edges SQL with columns: id, source, target, cost [,reverse_cost]
203+
- Points SQL with columns: [pid], edge_id, fraction[,side]
204+
- From ARRAY[vertices identifiers]
205+
- Distance
115206
- Optional Parameters
116207
- directed := true
117208
- details := false

0 commit comments

Comments
 (0)