Search Postgresql Archives

Array Comparison

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

 



I have a function that returns bigint[] and would like to be able to compare a bigint to the result.
 
freeload=> select fn_descendents('trip'::varchar,61::bigint);
          fn_descendents
-----------------------------------
 {935,815,689,569,446,325,205,191}
(1 row)
freeload=> select 935::bigint in (select fn_descendents('trip'::varchar,61::bigint));
ERROR:  operator does not exist: bigint = bigint[]
LINE 1: select 935::bigint in (select fn_descendents('trip'::varchar...
                           ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
This is probably super obvious but I'm not getting it right now.
 
Thank you all in advance!
 
- Ian

[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