Using array_agg in pgr_kdisjkstrpath() error

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

Responses

Browse pgsql-general by date

  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