[pgrouting-users] Problem with query
Stephen Woodbridge
woodbri at swoodbridge.com
Fri Jul 1 08:48:58 PDT 2016
What do you get if you do:
SELECT (pgr_bdDijkstra(...)).*
You should probably write this up as an issue.
-Steve
On 7/1/2016 11:08 AM, Worth Lutz wrote:
> Hi All,
>
> Can anyone explain the strange results (see below) I'm getting?
>
> ~$ apt-show-versions postgresql
> postgresql:all/trusty-updates 9.3+154ubuntu1 uptodate
>
> ~$ apt-show-versions postgis
> postgis:amd64/trusty 2.1.4+dfsg-3~trusty uptodate
>
> ~$ apt-show-versions postgresql-9.3-pgrouting
> postgresql-9.3-pgrouting:amd64/trusty 2.2.3-release-ppa1~trusty1 uptodate
>
>
> The first query gives me 4 values and the second has the 'id2' value empty.
>
> SELECT
> pgr_bdDijkstra(
> 'SELECT id_base AS id, source, target, cost_len AS cost, rcost_len
> AS reverse_cost FROM _rt_geom_streets_base',
> 11, 6, TRUE, TRUE
> );
> pgr_bddijkstra
> ---------------------------------
> (0,11,2087858,482.722955703)
> (1,3549,2082803,275.837140233)
> (2,24976,2086339,272.953707069)
> (3,20623,2086101,484.096255058)
> (4,48115,2085508,388.315542378)
> (5,47218,2084557,480.30350456)
> (6,8387,2094458,476.8149761)
> (7,248,2093906,255.35844989)
> (8,1348,2097029,247.294429215)
> (9,1536,2090136,339.718631568)
> (10,6465,2091005,330.978413622)
> (11,3740,2087980,415.137012292)
> (12,1504,2095856,375.236169771)
> (13,1505,2090458,466.482679764)
> (14,1130,2089855,481.831396537)
> (15,1116,2089664,470.256648783)
> (16,1117,2139494,262.774003918)
> (17,2907,2139496,73.1337200735)
> (18,765,2131538,172.32970181)
> (19,6,-1,0)
> (20 rows)
>
>
> SELECT *
> FROM
>
> pgr_bdDijkstra(
>
> 'SELECT id_base AS id, source, target, cost_len AS cost, rcost_len
> AS reverse_cost FROM _rt_geom_streets_base',
> 11, 6, TRUE, TRUE
> );
> seq | id1 | id2 | cost
> -----+-------+-----+---------------
> 0 | 11 | | 482.722955703
> 1 | 3549 | | 275.837140233
> 2 | 24976 | | 272.953707069
> 3 | 20623 | | 484.096255058
> 4 | 48115 | | 388.315542378
> 5 | 47218 | | 480.30350456
> 6 | 8387 | | 476.8149761
> 7 | 248 | | 255.35844989
> 8 | 1348 | | 247.294429215
> 9 | 1536 | | 339.718631568
> 10 | 6465 | | 330.978413622
> 11 | 3740 | | 415.137012292
> 12 | 1504 | | 375.236169771
> 13 | 1505 | | 466.482679764
> 14 | 1130 | | 481.831396537
> 15 | 1116 | | 470.256648783
> 16 | 1117 | | 262.774003918
> 17 | 2907 | | 73.1337200735
> 18 | 765 | | 172.32970181
> 19 | 6 | | 0
> (20 rows)
>
>
>
>
> --
> *Worth Lutz*
>
>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
More information about the Pgrouting-users
mailing list