usernames of a group from 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!