ANY for Array value check - Mailing list pgsql-sql

From Emi Lu
Subject ANY for Array value check
Date
Msg-id 4DF233DD.8000104@encs.concordia.ca
Whole thread Raw
List pgsql-sql
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');

What is the command?

Thanks a lot!
Emi




pgsql-sql by date:

Previous
From: Edgardo Portal
Date:
Subject: Re: need help with some aggregation magic
Next
From: "C. Bensend"
Date:
Subject: Returning a set of dates