Search Postgresql Archives

Re: Using array_agg in pgr_kdisjkstrpath() error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thursday, April 9, 2015, Marc-André Goderre <magoderre@xxxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux