Hello all,
I hope someone will can help me.
When I use pgr_kdijkstrapath function as this:
select * FROM pgr_kdijkstrapath('
SELECT d.id,
source::integer,
target::integer,
c.cost::double precision as cost
FROM way_topo_data d join way_cost c on d.id = c.id
where c.profile_id=5',
(select n1.start_id::integer from n1),
(select array_agg(end_id::integer)::integer[] as id from n2),
false,
false) p;
It return me the following error : One of the target vertices was not found or several targets are the same.
But when i take the result of the
(select array_agg(end_id::integer) ::integer[] as id from n2)
giving me "{28411,25582}" and hardcode it in the the statement as :
select * FROM pgr_kdijkstrapath('
SELECT d.id,
source::integer,
target::integer,
c.cost::double precision as cost
FROM way_topo_data d join way_cost c on d.id = c.id
where c.profile_id=5',
(select n1.start_id::integer from n1),
'{28411,25582}',
false,
false) p;
It works
Then, where's the difference between the result of (select array_agg(end_id::integer)::integer[] as id from n2) AND
'{28411,25582}'
Thanks
Marc