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 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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
