limitation using LIKE on ANY(array)
K C Lau <kclau60@netvigator.com>
From: K C Lau <kclau60@netvigator.com>
To: pgsql-performance@postgresql.org
Date: 2006-03-24T15:25:00Z
Lists: pgsql-performance
With 8.1.3, I get an error when trying to do this on a Text[] column : .. WHERE ANY(array) LIKE 'xx%' Indeed, I get rejected even with: .. WHERE ANY(array) = 'xx' In both cases, the error is: ERROR: syntax error at or near "any" ... It would only work as documented in the manual (8.10.5): SELECT * FROM sal_emp WHERE 10000 = ANY (pay_by_quarter); It appears that this restriction is still in place in 8.2: >http://developer.postgresql.org/docs/postgres/arrays.html Is that the case? Thanks in advance, KC.