pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: K C Lau <kclau60@netvigator.com>
To: pgsql-performance@postgresql.org
Subject: limitation using LIKE on ANY(array)
Date: Fri, 24 Mar 2006 23:25:00 +0800
Message-ID: <6.2.1.2.0.20060324225743.04d49ac0@localhost> (raw)
In-Reply-To: <20060324133252.GA22688@winnie.fuhr.org>
References: <200603170625.k2H6PJ926955@pillette.com>
	<1143112188.2810.27.camel@theo-laptop.int.coza.net.za>
	<20060323132448.GB4881@surnet.cl>
	<4423E90E.2090607@rentalia.com>
	<20060324125245.GB90527@pervasive.com>
	<4423EDA9.3090502@rentalia.com>
	<20060324130619.GF90527@pervasive.com>
	<20060324133252.GA22688@winnie.fuhr.org>


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. 

view thread (3+ messages)  latest in thread

Message-ID: <6.2.1.2.0.20060324225743.04d49ac0@localhost>
Permalink:  ../6.2.1.2.0.20060324225743.04d49ac0@localhost/
Also on:    postgresql.org/message-id/6.2.1.2.0.20060324225743.04d49ac0@localhost

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: kclau60@netvigator.com
  Subject: Re: limitation using LIKE on ANY(array)
  In-Reply-To: <6.2.1.2.0.20060324225743.04d49ac0@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox