Re: User/Groups

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.

In the postgreSQL contrib tree is modul (array_iterator) with operators
for arrays.

A solution for you:

SELECT usename
FROM pg_user, pg_group
WHERE pg_group.grolist *= pg_user.usesysid AND pg_group.grosysid = 1;

Karel

/* ----------------
* Karel Zak * zakkr(at)zf(dot)jcu(dot)cz * http://home.zf.jcu.cz/~zakkr/
* C, PostgreSQL, PHP, WWW, http://docs.linux.cz
* ----------------
*/