From: | Euler Taveira de Oliveira <euler(at)timbira(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: operator does not exist: smallint <> smallint[] |
Date: | 2008-12-09 13:48:33 |
Message-ID: | 493E7731.1070405@timbira.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom Lane escreveu:
> Euler Taveira de Oliveira <euler(at)timbira(dot)com> writes:
>> 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[]
>
> It's entirely right: there's no such operator.
>
Out of curiosity, why the other queries work?
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)
--
Euler Taveira de Oliveira
http://www.timbira.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff | 2008-12-09 13:55:19 | Re: multiple function execute using (func()).* |
Previous Message | Simon Riggs | 2008-12-09 13:47:30 | Re: Sync Rep: First Thoughts on Code |