Received: from meryl.it.uu.se (root@meryl.it.uu.se [130.238.12.42]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA06907 for ; Tue, 4 Apr 2000 06:25:20 -0400 (EDT) (envelope-from e99re41@DoCS.UU.SE) Received: from Utter.DoCS.UU.SE (e99re41@Utter.DoCS.UU.SE [130.238.9.105]) by meryl.it.uu.se (8.8.5/8.8.5) with ESMTP id MAA04861; Tue, 4 Apr 2000 12:25:12 +0200 (MET DST) Received: from localhost (e99re41@localhost) by Utter.DoCS.UU.SE (8.6.12/8.6.12) with ESMTP id MAA06083; Tue, 4 Apr 2000 12:25:10 +0200 X-Authentication-Warning: Utter.DoCS.UU.SE: e99re41 owned process doing -bs Date: Tue, 4 Apr 2000 12:25:10 +0200 (MET DST) From: Peter Eisentraut Reply-To: Peter Eisentraut To: Michael Fork cc: pgsql-sql@postgresql.org Subject: Re: User/Groups In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from QUOTED-PRINTABLE to 8bit by hub.org id GAA06968 X-Archive-Number: 200004/28 Somewhere in contrib/ there is some array walking code which is what you want. I'm not thoroughly familiar with it, though. On Mon, 3 Apr 2000, Michael Fork wrote: > I am trying to populate a select box on a form with all users in the group > with the sysid of 1 using the following query: > > SELECT usename FROM pg_user, pg_group WHERE pg_user.usesysid IN > pg_group.grolist AND pg_group.grosysid = 1; > > however, everytime I run it I recieve the following error: > > ERROR: parser: parse error at or near "pg_group" > > which leads me to belive that the IN operator is not correct, is there > another one that I should be using? Thanks in advance. -- Peter Eisentraut Sernanders väg 10:115 peter_e@gmx.net 75262 Uppsala http://yi.org/peter-e/ Sweden