On 2011-06-10, Emi Lu <em...@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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
