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: 6.2.1.2.0.20060324225743.04d49ac0@localhost (view raw or flat)
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:
>http://developer.postgresql.org/docs/postgres/arrays.html

Is that the case?

Thanks in advance,
KC. 

In response to

Responses

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-2014 The PostgreSQL Global Development Group