Re: BUG #2889: Syntax error: WHERE ANY(arrayfield) = N - Mailing list pgsql-bugs

"David" <higgsd@gmail.com> 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