Using array_agg in pgr_kdisjkstrpath() error
От | Marc-André Goderre |
---|---|
Тема | Using array_agg in pgr_kdisjkstrpath() error |
Дата | |
Msg-id | D8DAC91BA6256246BA3FF835F6AAA1189943BF0D@SI-MB01.cegep-chicoutimi.qc.ca обсуждение исходный текст |
Ответы |
Re: Using array_agg in pgr_kdisjkstrpath() error
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: