Re: Using array_agg in pgr_kdisjkstrpath() error

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Using array_agg in pgr_kdisjkstrpath() error
Дата
Msg-id CAKFQuwbAUy3fv_c5kR93qOJNVj0XQmE3P_RUqk_jDAcygonv8w@mail.gmail.com
обсуждение исходный текст
Ответ на Using array_agg in pgr_kdisjkstrpath() error  (Marc-André Goderre <magoderre@cgq.qc.ca>)
Список pgsql-general
On Thursday, April 9, 2015, Marc-André Goderre <magoderre@cgq.qc.ca> wrote:
Hello all,
I hope someone will can help me.

Then, where's the difference between the result of (select array_agg(end_id::integer)::integer[]  as id from n2) AND '{28411,25582}'

There isn't...though technically the former is an integer array and the later is an unknown literal.  It gets implicitly cast, I think, to an int[] so that it can get matched to the only? function with that name.

A self-contained example would likely help...those who are responsible for pgrouting.  The error is coming from the function so debugging it from the inside would help.

Does the order of the integers matter?

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: Marc-André Goderre
Дата:
Сообщение: Using array_agg in pgr_kdisjkstrpath() error
Следующее
От: Sameer Kumar
Дата:
Сообщение: Re: Limiting user from changing its own attributes