David Higgs wrote:
> On 1/13/07, Tom Lane <[EMAIL PROTECTED]> wrote:
> > "David" <[EMAIL PROTECTED]> writes:
> > > This statement works:
> > > => SELECT * FROM sal_emp WHERE 1 = ANY (pay_by_quarter);
> >
> > > But this does not:
> > > => SELECT * FROM sal_emp WHERE ANY (pay_by_quarter) = 1;
On 1/13/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"David" <[EMAIL PROTECTED]> writes:
> This statement works:
> => SELECT * FROM sal_emp WHERE 1 = ANY (pay_by_quarter);
> But this does not:
> => SELECT * FROM sal_emp WHERE ANY (pay_by_quarter) = 1;
> ERROR: syntax error at or near "ANY" a
"David" <[EMAIL PROTECTED]> writes:
> This statement works:
> => SELECT * FROM sal_emp WHERE 1 = ANY (pay_by_quarter);
> But this does not:
> => SELECT * FROM sal_emp WHERE ANY (pay_by_quarter) = 1;
> ERROR: syntax error at or near "ANY" at character ...
This is not a bug, it's the way t