From: | Marc-André Goderre <magoderre(at)cgq(dot)qc(dot)ca> |
---|---|
To: | "'pgsql-general(at)postgresql(dot)org' (pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Using array_agg in pgr_kdisjkstrpath() error |
Date: | 2015-04-09 17:14:11 |
Message-ID: | D8DAC91BA6256246BA3FF835F6AAA1189943BF0D@SI-MB01.cegep-chicoutimi.qc.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Volkan Unsal | 2015-04-09 17:15:55 | no pg_hba.conf entry for replication connection from host |
Previous Message | Vasudevan, Ramya | 2015-04-09 17:00:20 | Re: Finding values of bind variables |