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

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_constraint

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

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 ALL(select

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

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 comparisons

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

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');