<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Hi Steve,</p>
<p>That method gives the expected results running in psql on the
command line.</p>
<p>In pgAdmin, I got the previous results with no values in the id2
column.</p>
<p>I can get the missing id2 with SELECT pgr_bdDijkstra(..) on
pgAdmin also.</p>
<p>Confusion reigns here today!</p>
<p>I'll see if I can get a test case put together.<br>
</p>
<div class="moz-signature"><b>Worth Lutz</b><br>
<br>
<br>
</div>
<div class="moz-cite-prefix">On 7/1/2016 11:48 AM, Stephen
Woodbridge wrote:<br>
</div>
<blockquote
cite="mid:23431229-2439-3ffe-5398-dbbeefdd35ab@swoodbridge.com"
type="cite">What do you get if you do:
<br>
<br>
SELECT (pgr_bdDijkstra(...)).*
<br>
<br>
You should probably write this up as an issue.
<br>
<br>
-Steve
<br>
<br>
On 7/1/2016 11:08 AM, Worth Lutz wrote:
<br>
<blockquote type="cite">Hi All,
<br>
<br>
Can anyone explain the strange results (see below) I'm getting?
<br>
<br>
~$ apt-show-versions postgresql
<br>
postgresql:all/trusty-updates 9.3+154ubuntu1 uptodate
<br>
<br>
~$ apt-show-versions postgis
<br>
postgis:amd64/trusty 2.1.4+dfsg-3~trusty uptodate
<br>
<br>
~$ apt-show-versions postgresql-9.3-pgrouting
<br>
postgresql-9.3-pgrouting:amd64/trusty 2.2.3-release-ppa1~trusty1
uptodate
<br>
<br>
<br>
The first query gives me 4 values and the second has the 'id2'
value empty.
<br>
<br>
SELECT
<br>
pgr_bdDijkstra(
<br>
'SELECT id_base AS id, source, target, cost_len AS cost,
rcost_len
<br>
AS reverse_cost FROM _rt_geom_streets_base',
<br>
11, 6, TRUE, TRUE
<br>
);
<br>
pgr_bddijkstra
<br>
---------------------------------
<br>
(0,11,2087858,482.722955703)
<br>
(1,3549,2082803,275.837140233)
<br>
(2,24976,2086339,272.953707069)
<br>
(3,20623,2086101,484.096255058)
<br>
(4,48115,2085508,388.315542378)
<br>
(5,47218,2084557,480.30350456)
<br>
(6,8387,2094458,476.8149761)
<br>
(7,248,2093906,255.35844989)
<br>
(8,1348,2097029,247.294429215)
<br>
(9,1536,2090136,339.718631568)
<br>
(10,6465,2091005,330.978413622)
<br>
(11,3740,2087980,415.137012292)
<br>
(12,1504,2095856,375.236169771)
<br>
(13,1505,2090458,466.482679764)
<br>
(14,1130,2089855,481.831396537)
<br>
(15,1116,2089664,470.256648783)
<br>
(16,1117,2139494,262.774003918)
<br>
(17,2907,2139496,73.1337200735)
<br>
(18,765,2131538,172.32970181)
<br>
(19,6,-1,0)
<br>
(20 rows)
<br>
<br>
<br>
SELECT *
<br>
FROM
<br>
<br>
pgr_bdDijkstra(
<br>
<br>
'SELECT id_base AS id, source, target, cost_len AS cost,
rcost_len
<br>
AS reverse_cost FROM _rt_geom_streets_base',
<br>
11, 6, TRUE, TRUE
<br>
);
<br>
seq | id1 | id2 | cost
<br>
-----+-------+-----+---------------
<br>
0 | 11 | | 482.722955703
<br>
1 | 3549 | | 275.837140233
<br>
2 | 24976 | | 272.953707069
<br>
3 | 20623 | | 484.096255058
<br>
4 | 48115 | | 388.315542378
<br>
5 | 47218 | | 480.30350456
<br>
6 | 8387 | | 476.8149761
<br>
7 | 248 | | 255.35844989
<br>
8 | 1348 | | 247.294429215
<br>
9 | 1536 | | 339.718631568
<br>
10 | 6465 | | 330.978413622
<br>
11 | 3740 | | 415.137012292
<br>
12 | 1504 | | 375.236169771
<br>
13 | 1505 | | 466.482679764
<br>
14 | 1130 | | 481.831396537
<br>
15 | 1116 | | 470.256648783
<br>
16 | 1117 | | 262.774003918
<br>
17 | 2907 | | 73.1337200735
<br>
18 | 765 | | 172.32970181
<br>
19 | 6 | | 0
<br>
(20 rows)
<br>
<br>
<br>
<br>
<br>
--
<br>
*Worth Lutz*
<br>
<br>
<br>
<br>
<br>
_______________________________________________
<br>
Pgrouting-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a>
<br>
<br>
</blockquote>
<br>
<br>
---
<br>
This email has been checked for viruses by Avast antivirus
software.
<br>
<a class="moz-txt-link-freetext" href="https://www.avast.com/antivirus">https://www.avast.com/antivirus</a>
<br>
<br>
_______________________________________________
<br>
Pgrouting-users mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Pgrouting-users@lists.osgeo.org">Pgrouting-users@lists.osgeo.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/pgrouting-users">http://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
</blockquote>
<br>
</body>
</html>