Re: usernames of a group from SQL

O Kis Jαnos Tamαs έγραψε στις May 19, 2006 :

> Hi,
>
> At the first time: I'm in newbie in SQL... I'm sorry!
>
> My question is: How can I get the usernames of a group (for example
> 'osztatlan_users') from SQL?
>
> I try it:
>
> SELECT usename
> FROM pg_user
> WHERE usesysid IN (SELECT grolist FROM pg_group WHERE
> groname='osztatlan_users')
> ORDER BY pg_user;
>
> But I get the next error message:
>
> ERROR: operator does not exist: oid = oid[]
> HINT: No operator matches the given name and argument type(s). You
> may need to add explicit type casts.
>
> I see, what is the problem, but what can I do...?

SELECT u.usename from pg_user u,pg_group g where u.usesysid = any
(g.grolist) and g.groname='osztatlan_users';

>
> Thans,
> kjt
>
>
> McAfee SCM 4.1 αltal ellenυrizve!
>
> ---------------------------(end of broadcast)---------------------------TIP 4: Have you searched our list archives?
> http://archives.postgresql.org
>

--
-Achilleus