Re: select ARRAY[1, 4, 3] @> ARRAY[3, 1] gives ERROR: operator does not exist: integer[] @> integer[] ???

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Gagnon" <david(dot)gagnon(at)cesart(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: select ARRAY[1, 4, 3] @> ARRAY[3, 1] gives ERROR: operator does not exist: integer[] @> integer[] ???
Date: 2007-02-27 16:01:31
Message-ID: 20513.1172592091@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"David Gagnon" <david(dot)gagnon(at)cesart(dot)com> writes:
> I tried select ARRAY[1,4,3] @> ARRAY[3,1] in pgAdminIII and get an error.
> ...
> Thanks to point me what I'm doing wrong or how to fix this :-/

Don't use the 8.2 manuals as a guide to an 8.1 or older PG? That
operator is new in 8.2.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-02-27 16:15:53 Re: Unable to restore dump due to client encoding issues -- or, when is SQL_ASCII really UTF8
Previous Message Michael Fuhr 2007-02-27 15:52:28 Re: Unable to restore dump due to client encoding issues -- or, when is SQL_ASCII really UTF8