limitation using LIKE on ANY(array) - Mailing list pgsql-performance

From K C Lau
Subject limitation using LIKE on ANY(array)
Date
Msg-id 6.2.1.2.0.20060324225743.04d49ac0@localhost
Whole thread Raw
In response to Re: Array performance  (Michael Fuhr <mike@fuhr.org>)
Responses Re: limitation using LIKE on ANY(array)  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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.

pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: Scaling up PostgreSQL in Multiple CPU / Dual Core
Next
From: Tom Lane
Date:
Subject: Re: Array performance