Received: from aserver.apotres.edu.lb ([194.126.24.131]) by hub.org (8.9.1/8.9.1) with ESMTP id BAA26655 for ; Thu, 5 Nov 1998 01:35:26 -0500 (EST) (envelope-from rkhoury@apotres.edu.lb) Received: from apotres.edu.lb ([194.126.24.132]) by aserver.apotres.edu.lb (Netscape Messaging Server 3.01) with ESMTP id 184 for ; Thu, 5 Nov 1998 08:29:01 +0000 Message-ID: <36414688.F6E97316@apotres.edu.lb> Date: Thu, 05 Nov 1998 08:32:40 +0200 From: "rony khoury" Reply-To: rkhoury@apotres.edu.lb X-Mailer: Mozilla 4.5 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgreSQL.org" Subject: select b[1] from foo Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hello , Say I perform the following operations on my postgresql box : create table foo (a int , b int[]) ; insert into foo values(1,'{1,2,3}'); select * from foo ; a | b --------------- 1 | {1,2,3} select b[2] from foo ; the question is why can't I execute the following statement , and If I want to do an add , avg , sum , etc ... on the same element , how can I do that ? If someone can provide me with an example on how to do that I will be gratefull . thanks , Rony .