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

From: "David Gagnon" <david(dot)gagnon(at)cesart(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: select ARRAY[1, 4, 3] @> ARRAY[3, 1] gives ERROR: operator does not exist: integer[] @> integer[] ???
Date: 2007-02-27 15:37:24
Message-ID: 00b401c75a85$2dcc9180$7401a8c0@cesart.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I tried select ARRAY[1,4,3] @> ARRAY[3,1] in pgAdminIII and get an error.
This example comes directly from the postgresql manual section: 9.14. Array
Functions and Operators.

Did I screw up something ? I tried on a 8.1 postgreql and get the same
error.

ERROR: operator does not exist: integer[] @> integer[]
SQL state: 42883
Hint: No operator matches the given name and argument type(s). You may need
to add explicit type casts.

Thanks to point me what I'm doing wrong or how to fix this :-/

Regards

David

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-02-27 15:39:35 Re: dropping a master table and all of its partitions?
Previous Message Bill Moran 2007-02-27 15:31:47 Re: Unable to restore dump due to client encoding issues -- or, when is SQL_ASCII really UTF8