From: | Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE> |
---|---|
To: | Michael Fork <mfork(at)toledolink(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: User/Groups |
Date: | 2000-04-04 10:25:10 |
Message-ID: | Pine.GSO.4.02A.10004041224190.6042-100000@Utter.DoCS.UU.SE |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-04-04 10:34:04 | Re: Outer-joins |
Previous Message | Gerhard Dieringer | 2000-04-04 08:03:27 | Outer-joins |