Thread: how to use arrays?

Let's assume the following structure:
  create table T1 (name char(20), code int[]);
  insert into T1 values('abcd', '{1,2,3}');
  ...
  insert into T1 values('xyz', '{3,1}');

Now i want to select all names which contains code=1
SELECT name FROM T1 WHERE 1=T1.code[1] or 1=T1.code[2] ... etc ???

--
        ___
       <o-o>    Viorel ANGHEL <vang@altavista.net>
       [`-']
       -"-"-