On 2011-06-10, Emi Lu 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 arra
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
--
Sent via pgsq
