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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
