Official functions changes
- #2516 Standarize output pgr_aStar
- Standarizing output columns to (seq, path_seq, start_vid, end_vid, node, edge, cost, agg_cost)
- pgr_aStar (One to One) added start_vid and end_vid columns.
- pgr_aStar (One to Many) added end_vid column.
- pgr_aStar (Many to One) added start_vid column.
- Standarizing output columns to (seq, path_seq, start_vid, end_vid, node, edge, cost, agg_cost)
- #2523 Standarize output pgr_bdAstar
- Standarizing output columns to (seq, path_seq, start_vid, end_vid, node, edge, cost, agg_cost)
- pgr_bdAstar (One to One) added start_vid and end_vid columns.
- pgr_bdAstar (One to Many) added end_vid column.
- pgr_bdAstar (Many to One) added start_vid column.
- Standarizing output columns to (seq, path_seq, start_vid, end_vid, node, edge, cost, agg_cost)
- #2547 Standarize output and modifying signature pgr_KSP
- Result columns standarized to: (seq, path_id, path_seq, start_vid, end_vid, node, edge, cost, agg_cost)
- pgr_ksp (One to One)
- Added start_vid and end_vid result columns.
- New overload functions:
- pgr_ksp (One to Many)
- pgr_ksp (Many to One)
- pgr_ksp (Many to Many)
- pgr_ksp (Combinations)
- #2548 Standarize output pgr_drivingdistance
- Standarizing output columns to (seq, depth, start_vid, pred, node, edge, cost, agg_cost)
- pgr_drivingdistance (Single vertex)
- Added depth and start_vid result columns.
- pgr_drivingdistance (Multiple vertices)
- Result column name change: from_v to start_vid.
- Added depth and pred result columns.
- pgr_drivingdistance (Single vertex)
- Standarizing output columns to (seq, depth, start_vid, pred, node, edge, cost, agg_cost)
Proposed functions changes
- #2544 Standarize output and modifying signature pgr_withPointsDD
- Signature change: driving_side parameter changed from named optional to unnamed compulsory driving side.
- pgr_withPointsDD (Single vertex)
- pgr_withPointsDD (Multiple vertices)
- Standarizing output columns to (seq, depth, start_vid, pred, node, edge, cost, agg_cost)
- pgr_withPointsDD (Single vertex)
- Added depth, pred and start_vid column.
- pgr_withPointsDD (Multiple vertices)
- Added depth, pred columns.
- pgr_withPointsDD (Single vertex)
- When details is false:
- Only points that are visited are removed, that is, points reached within the distance are included
- Deprecated signatures
- pgr_withpointsdd(text,text,bigint,double precision,boolean,character,boolean)
- pgr_withpointsdd(text,text,anyarray,double precision,boolean,character,boolean,boolean)
- Signature change: driving_side parameter changed from named optional to unnamed compulsory driving side.
- #2546 Standarize output and modifying signature pgr_withPointsKSP
- Standarizing output columns to (seq, path_id, path_seq, start_vid, end_vid, node, edge, cost, agg_cost)
- pgr_withPointsKSP (One to One)
- Signature change: driving_side parameter changed from named optional to unnamed compulsory driving side.
- Added start_vid and end_vid result columns.
- New overload functions
- pgr_withPointsKSP (One to Many)
- pgr_withPointsKSP (Many to One)
- pgr_withPointsKSP (Many to Many)
- pgr_withPointsKSP (Combinations)
- Deprecated signature
- pgr_withpointsksp(text,text,bigint,bigint,integer,boolean,boolean,char,boolean)
C/C++ code enhancements
- #2504 To C++ pg data get, fetch and check.
- Stopping support for compilation with MSVC.
- #2505 Using namespace.
- #2512 [Dijkstra] Removing duplicate code on Dijkstra.
- #2517 Astar code simplification.
- #2521 Dijkstra code simplification.
- #2522 bdAstar code simplification.
Documentation
- #2490 Automatic page history links.
SQL standarization
- #2555 standarize deprecated messages
- On new internal function: do not use named parameters and default parameters.
To update your database
Download the packaged version from your operating system, and use this command in the database:
ALTER EXTENSION pgrouting UPDATE TO "3.6.0";
—
Regards,
pgRouting Team.
