Re: [HACKERS] operator does not exist: smallint <> smallint[]

2008-12-09 Thread Tom Lane
Euler Taveira de Oliveira <[EMAIL PROTECTED]> writes: > Tom Lane escreveu: >> It's entirely right: there's no such operator. >> > Out of curiosity, why the other queries work? The behavior is different depending on whether the argument of ANY/ALL is a sub-SELECT or not. If it is, then the compar

Re: [HACKERS] operator does not exist: smallint <> smallint[]

2008-12-09 Thread Euler Taveira de Oliveira
Tom Lane escreveu: > Euler Taveira de Oliveira <[EMAIL PROTECTED]> 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 <> >> AL

Re: [HACKERS] operator does not exist: smallint <> smallint[]

2008-12-09 Thread Tom Lane
Euler Taveira de Oliveira <[EMAIL PROTECTED]> 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_con

[HACKERS] operator does not exist: smallint <> smallint[]

2008-12-08 Thread Euler Taveira de Oliveira
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'); ER