Re: usernames of a group from SQL - Mailing list pgsql-sql

From Achilleus Mantzios
Subject Re: usernames of a group from SQL
Date
Msg-id Pine.LNX.4.44.0605191304380.3491-100000@matrix.gatewaynet.com
Whole thread Raw
In response to usernames of a group from SQL  (Kis János Tamás <kjt@takarnet.hu>)
Responses Re: usernames of a group from SQL
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



pgsql-sql by date:

Previous
From: Kis János Tamás
Date:
Subject: usernames of a group from SQL
Next
From: Kaloyan Iliev
Date:
Subject: Problem with SET CONSTRAINTS ALL DEFERRED;