Array Comparison

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

Responses

Browse pgsql-general by date

  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