Re: usernames of a group from SQL - Mailing list pgsql-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