On 1/13/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"David" <[EMAIL PROTECTED]> writes:
> This statement works:
> => SELECT * FROM sal_emp WHERE 10000 = ANY (pay_by_quarter);
> But this does not:
> => SELECT * FROM sal_emp WHERE ANY (pay_by_quarter) = 10000;
> ERROR: syntax error at or near "ANY" at character ...
This is not a bug, it's the way the syntax works per SQL spec.
ANY must immediately follow the operator it relates to. See
<quantified comparison predicate> syntax in the spec.
regards, tom lane
Aha, I see it in the docs now, although it's still rather unintuitive.
Could the appropriate section on arrays be crosslinked to the ANY/ALL
page, to preempt this question in the future?
Thanks.
--david
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
