Re: [SQL] querying array

On Tue, 9 Jun 1998, Dim Zegebart wrote:

> Hi,
> is there any way to do selection from table by testing array attribute
> for
> presence of defined value ?
> SQL speaking :
> create tabel foo(n int2[]);
> insert into foo (n) values('{1,2,3}');
> insert into foo (n) values('{4,7,8,5}');
> insert into foo (n) values('{4,5}');
> //now I want to select only exeplars with n containing '5'. It should be
> second and third records :
> select * from foo where foo.n?????
> //That I shoud type next ?
>
select * from foo where foo.n[1]=5 or foo.n[2]=5 or foo.n[4]=5;
n
---------
{4,7,8,5}
{4,5}
(2 rows)
Jose'