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(at)altavista(dot)net>
[`-']
-"-"-