| From: | "David" <higgsd(at)gmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #2889: Syntax error: WHERE ANY(arrayfield) = N |
| Date: | 2007-01-13 05:49:28 |
| Message-ID: | 200701130549.l0D5nSZl054595@wwwmaster.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2889
Logged by: David
Email address: higgsd(at)gmail(dot)com
PostgreSQL version: 8.1.5
Operating system: OpenBSD 3.9
Description: Syntax error: WHERE ANY(arrayfield) = N
Details:
In reference to the array documentation at:
http://www.postgresql.org/docs/8.1/static/arrays.html#AEN5698
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 ...
The ANY operator has the same problem, others may as well.
While trivial to work around, it is certainly annoying and I can't think of
a good reason why it shouldn't work either way.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-01-13 18:46:15 | Re: BUG #2889: Syntax error: WHERE ANY(arrayfield) = N |
| Previous Message | Tom Lane | 2007-01-13 03:21:28 | Re: BUG #2885: to_char function |