Skip site navigation (1) Skip section navigation (2)

limitation using LIKE on ANY(array)

From: K C Lau <kclau60(at)netvigator(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: limitation using LIKE on ANY(array)
Date: 2006-03-24 15:25:00
Message-ID: (view raw or whole thread)
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:

Is that the case?

Thanks in advance,

In response to


pgsql-performance by date

Next:From: Tom LaneDate: 2006-03-24 15:51:44
Subject: Re: Array performance
Previous:From: Luke LonerganDate: 2006-03-24 15:02:15
Subject: Re: Scaling up PostgreSQL in Multiple CPU / Dual Core

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group