Search Postgresql Archives

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

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

To: "David Gagnon" <david.gagnon@xxxxxxxxxx>
Subject: Re: select ARRAY[1,4,3] @> ARRAY[3,1] gives ERROR: operator does not exist: integer[] @> integer[] ???
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Tue, 27 Feb 2007 11:01:31 -0500
Cc: pgsql-general@xxxxxxxxxxxxxx
Comments: In-reply-to "David Gagnon" <david.gagnon@xxxxxxxxxx> message dated "Tue, 27 Feb 2007 10:37:24 -0500"
In-reply-to: <00b401c75a85$2dcc9180$7401a8c0@xxxxxxxxxxxx>
References: <00b401c75a85$2dcc9180$7401a8c0@xxxxxxxxxxxx>

"David Gagnon" <david.gagnon@xxxxxxxxxx> 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

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

Follow-Ups:
- Re: select ARRAY[1,4,3] @> ARRAY[3,1] gives ERROR: operator does not exist: integer[] @> integer[] ???
  - From: David Gagnon

References:
- select ARRAY[1,4,3] @> ARRAY[3,1] gives ERROR: operator does not exist: integer[] @> integer[] ???
  - From: David Gagnon

Prev by Date: Re: Unable to restore dump due to client encoding issues -- or, when is SQL_ASCII really UTF8
Next by Date: Re: Unable to restore dump due to client encoding issues -- or, when is SQL_ASCII really UTF8
Previous by thread: select ARRAY[1,4,3] @> ARRAY[3,1] gives ERROR: operator does not exist: integer[] @> integer[] ???
Next by thread: Re: select ARRAY[1,4,3] @> ARRAY[3,1] gives ERROR: operator does not exist: integer[] @> integer[] ???
Index(es):
- Date
- Thread

[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]