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

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...?

Thans,
kjt


McAfee SCM 4.1 által ellenőrizve!