Thread

1. querying array

   Dim Zegebart <zager@post.comstar.ru> — 1998-06-09T12:27:36Z

   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 ?
   
   Thank in advance.
   
   --
   ____ ____
   |   \   /   Dim Zegebart
   ____/____
   
   Moscow Russia
   WWW - http://www.geocities.com/siliconvalley/pines/7817
   
   
   
   

2. Re: [SQL] querying array

   jose' soares <sferac@bo.nettuno.it> — 1998-06-09T14:50:50Z

   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'