[pgrouting-users] Problem with query

[Stephen Woodbridge]

On 7/1/2016 12:07 PM, Worth Lutz wrote:
> Hi Steve,
>
> That method gives the expected results running in psql on the command line.

Ahhh! OK, I would go with the results from the commandline. pgAdmin has 
bugs where is does not always display the results in all columns. I'm 
guessing that if you click one of the blank cells in id2 and copy and 
then paste it somewhere you will likely get a result value. Or is you 
run the query and save the results to a cvs file it will have values.

If this is the case, then this particular issue not a pgRouting bug, but 
a pgAdmin issue.

-Steve

> In pgAdmin, I got the previous results with no values in the id2 column.
>
> I can get the missing id2 with SELECT pgr_bdDijkstra(..) on pgAdmin also.
>
> Confusion reigns here today!
>
> I'll see if I can get a test case put together.
>
> *Worth Lutz*
>
>
> On 7/1/2016 11:48 AM, Stephen Woodbridge wrote:
>> 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
>>
>> _______________________________________________
>> Pgrouting-users mailing list
>> Pgrouting-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
>
> _______________________________________________
> 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