Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 5AEF3475CA6
	for <pgsql-sql@postgresql.org>; Sat, 29 Jun 2002 07:42:52 -0400 (EDT)
Mailbox-Line: From quadratini@sni.ph  Sat Jun 29 07:42:52 2002
Received: from ns.sni.ph (ns.sni.ph [210.23.103.9])
	by postgresql.org (Postfix) with ESMTP id C5D7C475C8D
	for <pgsql-sql@postgresql.org>; Sat, 29 Jun 2002 07:42:50 -0400 (EDT)
Received: (from root@localhost) by ns.sni.ph (8.11.6/8.11.6) id g5TBgrh91606
	for pgsql-sql@postgresql.org; Sat, 29 Jun 2002 19:42:53 +0800 (PHT)
Received: from sni.ph ([210.23.103.26])
	by ns.sni.ph (8.11.6/8.11.6) with ESMTP id g5TBgq291541
	for <pgsql-sql@postgresql.org>; Sat, 29 Jun 2002 19:42:52 +0800 (PHT)
Message-ID: <3D1D9EA9.3090604@sni.ph>
Date: Sat, 29 Jun 2002 19:48:57 +0800
From: Kelly <quadratini@sni.ph>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:0.9.4) Gecko/20011019 Netscape6/6.2
X-Accept-Language: en-us
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: selecting from integer[]
X-scanner: scanned by SNI 1.0.10 - (http://www.sni.ph)
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam-Status: No, hits=-0.1 required=5.0 tests=FROM_NAME_NO_SPACES
	version=2.30
X-Spam-Level: 
X-Archive-Number: 200206/411
X-Sequence-Number: 8376


select * from pg_user where usesysid=(select grolist[1] from pg_group 
where groname='mygroup');
select * from pg_user where usesysid=(select grolist[2] from pg_group 
where groname='mygroup');
select * from pg_user where usesysid=(select grolist[3] from pg_group 
where groname='mygroup');

Can those three queries be merged to one query? (and still gives me 
those three rows)
Or do I have to explicitly say grolist[1], grolist[2], etc....

Thanks in advance :)