Received: from bsd.post.comstar.ru (bsd.post.comstar.ru [195.210.131.10]) by hub.org (8.8.8/8.7.5) with ESMTP id IAA22302 for ; Tue, 9 Jun 1998 08:25:51 -0400 (EDT) Message-ID: <357D2A38.4892C577@post.comstar.ru> Date: Tue, 09 Jun 1998 16:27:36 +0400 From: Dim Zegebart Reply-To: zager@post.comstar.ru Organization: Comstar Ltd. X-Mailer: Mozilla 4.04 [en] (WinNT; I) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: querying array Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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