From: | Ian Harding <harding(dot)ian(at)gmail(dot)com> |
---|---|
To: | General PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
Subject: | Array Comparison |
Date: | 2014-12-06 00:55:10 |
Message-ID: | CAMR4UwEUkegfhY5=P0bpxxfB09rSYcNWp+8CJvD9FX7nBuxbTQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ian Harding | 2014-12-06 00:59:01 | Re: Array Comparison |
Previous Message | David G Johnston | 2014-12-05 22:01:58 | Re: autovacuum with inheritance |