Using array_agg in pgr_kdisjkstrpath() error

[Marc-André Goderre <magoderre@xxxxxxxxx>]

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






-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general