Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA58908 for ; Thu, 5 Aug 1999 12:07:31 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id MAA04812; Thu, 5 Aug 1999 12:06:18 -0400 (EDT) To: Olivier Ertz cc: "pgsql-sql@postgreSQL.org" Subject: Re: [SQL] Array of integer In-reply-to: Your message of Thu, 05 Aug 1999 17:48:34 +0200 <37A9B252.43DE2311@illite.u-strasbg.fr> Date: Thu, 05 Aug 1999 12:06:18 -0400 Message-ID: <4810.933869178@sss.pgh.pa.us> From: Tom Lane Olivier Ertz writes: > in pg_group, grolist give the list of the members of the group > how can i extract with a select request, not the whole list, but first > the one, the second, etc ... like : > select grolist[i] from pg_group where ... > i is varying from 0..N In releases through 6.5 you have to write array references as a fully qualified name: select pg_group.grolist[i] from pg_group where ... This is fixed for 6.6... regards, tom lane