Re: [BUGS] BUG #2889: Syntax error: WHERE ANY(arrayfield) = N

2007-01-19 Thread Bruce Momjian
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;

Re: [BUGS] BUG #2889: Syntax error: WHERE ANY(arrayfield) = N

2007-01-15 Thread David Higgs
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

Re: [BUGS] BUG #2889: Syntax error: WHERE ANY(arrayfield) = N

2007-01-13 Thread Tom Lane
"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