Euler Taveira de Oliveira <euler(at)timbira(dot)com> 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 are between the
LHS and the successive values produced by the sub-SELECT. If it isn't,
then the RHS has to produce an array and the comparisons are to the
array elements.
regards, tom lane