From: Jasen Betts <jasen@xnet.co.nz>
To: pgsql-sql@postgresql.org
Subject: Re: ANY for Array value check
Date: 11 Jun 2011 09:59:42 GMT
Message-ID: <isveae$knm$1@reversiblemaps.ath.cx> (raw)
References: <4DF233DD.8000104@encs.concordia.ca>
On 2011-06-10, Emi Lu <emilu@encs.concordia.ca> wrote:
> Good morning,
>
> String array compare command, I forgot how to do it.
>
> E.g.,
> create table z_drop(id varchar[]);
> insert into z_drop values('{"a1", "a2", "b1", "b2", "b3"}');
>
> I'd like to do:
>
> select * from z_drop where id = any('a1', 'b1');
use the array overlap operator:
select * from z_drop where id && ARRAY['a1'::varchar, 'b1'];
If you define the column as text[] instead of varchar you don't need
the ::varchar cast above. there's no postgres reason to prefer
(unbounded) varchar to text.
--
⚂⚃ 100% natural
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-sql@postgresql.org
Cc: jasen@xnet.co.nz
Subject: Re: ANY for Array value check
In-Reply-To: <isveae$knm$1@reversiblemaps.ath.cx>
* 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