operator does not exist: smallint <> smallint[]

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: operator does not exist: smallint <> smallint[]
Date: 2008-12-09 04:31:05
Message-ID: 493DF489.7060609@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I saw a report at .br mailing list [1] complaining about the message's title.
I do not try to investigate it. Am I missing something?

euler=# select attname from pg_attribute where attnum > 0 and attnum <>
ALL(select conkey from pg_constraint where conrelid = attrelid and contype = 'p');
ERROR: operator does not exist: smallint <> smallint[]
LINHA 1: ...ame from pg_attribute where attnum > 0 and attnum <> ALL(sel...
^
DICA: No operator matches the given name and argument type(s). You might need
to add explicit type casts.
euler=# select 1::smallint <> ALL(array[2::smallint, 3::smallint]);
?column?
----------
t
(1 registro)

euler=# select 1::smallint <> ALL(array[1::smallint, 2::smallint,3::smallint]);
?column?
----------
f
(1 registro)

euler=# select 1::smallint <> ALL(array[1, 2, 3]);
?column?
----------
f
(1 registro)

[1] http://listas.postgresql.org.br/pipermail/pgbr-geral/2008-December/013277.html

--
Euler Taveira de Oliveira
http://www.timbira.com/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2008-12-09 04:33:27 Re: Multiplexing SUGUSR1
Previous Message Andrew Chernow 2008-12-09 04:09:48 Re: parallel restore vs. windows