Received: from unixserv.rz.fh-hannover.de (root@rzgw.rz.fh-hannover.de [141.71.1.10]) by hub.org (8.9.3/8.9.3) with SMTP id GAA12670 for ; Tue, 18 May 1999 06:09:32 -0400 (EDT) (envelope-from wilms@stud.fh-hannover.de) Received: from schering.si2.uni-hannover.de by unixserv.rz.fh-hannover.de (AIX 3.2/UCB 5.64/4.03) id AA28734; Tue, 18 May 1999 12:15:43 +0200 Sender: wilms@unixserv.rz.fh-hannover.de Message-Id: <37413B01.48BABC87@stud.fh-hannover.de> Date: Tue, 18 May 1999 12:03:46 +0200 From: Heiko Wilms Organization: Schering-Institut X-Mailer: Mozilla 4.5 [en] (X11; I; Linux 2.0.35 i586) X-Accept-Language: en Mime-Version: 1.0 To: pgsql-sql@postgresql.org Subject: querying arrays Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi, I stucked upon the following situation: create table test ( n int[] ); insert into test values ( '{1,2,3,4}' ); now I need a query that returns all four numbers in different variables,i.e. an array like n[1],...,n[4] I tried queries like select test.n from test which returns {1,2,3,4} or select test.n[i] from test, where i is 1,2,3 or 4 which each returns 1,2,... What I'm looking for is a query that returns four rows with one number in each result index. Can anyone help? -- H. Wilms Homepage schering.si2.uni-hannover.de/hugo email wilms@stud.fh-hannover.de