pgrouting/sql/astar/astar.sql at main · PostGraphDB/pgrouting · GitHub

History

259 lines (214 loc) · 6.56 KB

Raw

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

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

File: astar.sql

Generated with Template by:

Mail: project@pgrouting.org

Function's developer:

Mail:

------

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*/

-----------------

-- pgr_aStar

-----------------

--v2.6

CREATE FUNCTION pgr_aStar(

TEXT, -- edges sql (required)

BIGINT, -- from_vid (required)

BIGINT, -- to_vid (required)

directed BOOLEAN DEFAULT true,

heuristic INTEGER DEFAULT 5,

factor FLOAT DEFAULT 1.0,

epsilon FLOAT DEFAULT 1.0,

OUT seq INTEGER,

OUT path_seq INTEGER,

OUT node BIGINT,

OUT edge BIGINT,

OUT cost FLOAT,

OUT agg_cost FLOAT)

RETURNS SETOF RECORD AS

$BODY$

SELECT a.seq, a.path_seq, a.node, a.edge, a.cost, a.agg_cost

FROM _pgr_aStar(_pgr_get_statement($1), ARRAY[$2]::BIGINT[], ARRAY[$3]::BIGINT[], $4, $5, $6::FLOAT, $7::FLOAT) AS a;

$BODY$

LANGUAGE sql VOLATILE STRICT

COST 100

ROWS 1000;

--v2.6

CREATE FUNCTION pgr_aStar(

TEXT, -- edges sql (required)

BIGINT, -- from_vid (required)

ANYARRAY, -- to_vids (required)

directed BOOLEAN DEFAULT true,

heuristic INTEGER DEFAULT 5,

factor FLOAT DEFAULT 1.0,

epsilon FLOAT DEFAULT 1.0,

OUT seq INTEGER,

OUT path_seq INTEGER,

OUT end_vid BIGINT,

OUT node BIGINT,

OUT edge BIGINT,

OUT cost FLOAT,

OUT agg_cost FLOAT)

RETURNS SETOF RECORD AS

$BODY$

SELECT a.seq, a.path_seq, a.end_vid, a.node, a.edge, a.cost, a.agg_cost

FROM _pgr_aStar(_pgr_get_statement($1), ARRAY[$2]::BIGINT[], $3::BIGINT[], $4, $5, $6::FLOAT, $7::FLOAT) AS a;

$BODY$

LANGUAGE sql VOLATILE STRICT

COST 100

ROWS 1000;

--v2.6

CREATE FUNCTION pgr_aStar(

TEXT, -- edges sql (required)

ANYARRAY, -- from_vids (required)

BIGINT, -- to_vid (required)

directed BOOLEAN DEFAULT true,

heuristic INTEGER DEFAULT 5,

factor FLOAT DEFAULT 1.0,

epsilon FLOAT DEFAULT 1.0,

OUT seq INTEGER,

OUT path_seq INTEGER,

OUT start_vid BIGINT,

OUT node BIGINT,

OUT edge BIGINT,

OUT cost FLOAT,

OUT agg_cost FLOAT)

RETURNS SETOF RECORD AS

$BODY$

SELECT a.seq, a.path_seq, a.start_vid, a.node, a.edge, a.cost, a.agg_cost

FROM _pgr_aStar(_pgr_get_statement($1), $2::BIGINT[], ARRAY[$3]::BIGINT[], $4, $5, $6::FLOAT, $7::FLOAT, normal:=false) AS a;

$BODY$

LANGUAGE sql VOLATILE STRICT

COST 100

ROWS 1000;

--v2.6

CREATE FUNCTION pgr_aStar(

TEXT, -- edges sql (required)

ANYARRAY, -- from_vids (required)

ANYARRAY, -- to_vids (required)

directed BOOLEAN DEFAULT true,

heuristic INTEGER DEFAULT 5,

factor FLOAT DEFAULT 1.0,

epsilon FLOAT DEFAULT 1.0,

OUT seq INTEGER,

OUT path_seq INTEGER,

OUT start_vid BIGINT,

OUT end_vid BIGINT,

OUT node BIGINT,

OUT edge BIGINT,

OUT cost FLOAT,

OUT agg_cost FLOAT)

RETURNS SETOF RECORD AS

$BODY$

SELECT *

FROM _pgr_aStar(_pgr_get_statement($1), $2::BIGINT[], $3::BIGINT[], $4, $5, $6::FLOAT, $7::FLOAT) AS a;

$BODY$

LANGUAGE sql VOLATILE STRICT

COST 100

ROWS 1000;

--v3.2

CREATE FUNCTION pgr_aStar(

TEXT, -- edges sql (required)

TEXT, -- combinations_sql (required)

directed BOOLEAN DEFAULT true,

heuristic INTEGER DEFAULT 5,

factor FLOAT DEFAULT 1.0,

epsilon FLOAT DEFAULT 1.0,

OUT seq INTEGER,

OUT path_seq INTEGER,

OUT start_vid BIGINT,

OUT end_vid BIGINT,

OUT node BIGINT,

OUT edge BIGINT,

OUT cost FLOAT,

OUT agg_cost FLOAT)

RETURNS SETOF RECORD AS

$BODY$

SELECT *

FROM _pgr_aStar(_pgr_get_statement($1), _pgr_get_statement($2), $3, $4, $5::FLOAT, $6::FLOAT) AS a;

$BODY$

LANGUAGE sql VOLATILE STRICT

COST 100

ROWS 1000;

-- COMMENTS

COMMENT ON FUNCTION pgr_aStar(TEXT, BIGINT, BIGINT, BOOLEAN, INTEGER, FLOAT, FLOAT)

IS 'pgr_aStar(One to One)

- Parameters:

- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2

- From vertex identifier

- To vertex identifier

- Optional Parameters:

- directed := true

- heuristic := 5

- factor := 1

- epsilon := 1

- Documentation:

- ${PROJECT_DOC_LINK}/pgr_aStar.html

COMMENT ON FUNCTION pgr_aStar(TEXT, BIGINT, ANYARRAY, BOOLEAN, INTEGER, FLOAT, FLOAT)

IS 'pgr_aStar(One to Many)

- Parameters:

- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2

- From vertex identifier

- To ARRAY[vertices identifiers]

- Optional Parameters:

- directed := true

- heuristic := 5

- factor := 1

- epsilon := 1

- Documentation:

- ${PROJECT_DOC_LINK}/pgr_aStar.html

COMMENT ON FUNCTION pgr_aStar(TEXT, ANYARRAY, BIGINT, BOOLEAN, INTEGER, FLOAT, FLOAT)

IS 'pgr_aStar(Many to One)

- Parameters:

- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2

- From ARRAY[vertices identifiers]

- To vertex identifier

- Optional Parameters:

- directed := true

- heuristic := 5

- factor := 1

- epsilon := 1

- Documentation:

- ${PROJECT_DOC_LINK}/pgr_aStar.html

COMMENT ON FUNCTION pgr_aStar(TEXT, ANYARRAY, ANYARRAY, BOOLEAN, INTEGER, FLOAT, FLOAT)

IS 'pgr_aStar(Many to Many)

- Parameters:

- edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2

- From ARRAY[vertices identifiers]

- To ARRAY[vertices identifiers]

- Optional Parameters:

- directed := true

- heuristic := 5

- factor := 1

- epsilon := 1

- Documentation:

- ${PROJECT_DOC_LINK}/pgr_aStar.html

COMMENT ON FUNCTION pgr_aStar(TEXT, TEXT, BOOLEAN, INTEGER, FLOAT, FLOAT)

IS 'pgr_aStar(Combinations)

- Parameters:

- Edges SQL with columns: id, source, target, cost [,reverse_cost], x1, y1, x2, y2

- Combinations SQL with columns: source, target

- Optional Parameters:

- directed := true

- heuristic := 5

- factor := 1

- epsilon := 1

- Documentation:

- ${PROJECT_DOC_LINK}/pgr_aStar.html

pgrouting/sql/astar/astar.sql at main · PostGraphDB/pgrouting · GitHub

Uh oh!

Expand file tree

Breadcrumbs

astar.sql

Latest commit

History

Breadcrumbs

astar.sql

File metadata and controls