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:
Is that the case?
Thanks in advance,
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2006-03-24 15:51:44|
|Subject: Re: Array performance |
|Previous:||From: Luke Lonergan||Date: 2006-03-24 15:02:15|
|Subject: Re: Scaling up PostgreSQL in Multiple CPU / Dual Core|