select * from pg_user where usesysid=(select grolist[1] from pg_group where groname='mygroup'); select * from pg_user where usesysid=(select grolist[2] from pg_group where groname='mygroup'); select * from pg_user where usesysid=(select grolist[3] from pg_group where groname='mygroup');
Can those three queries be merged to one query? (and still gives me those three rows) Or do I have to explicitly say grolist[1], grolist[2], etc.... Thanks in advance :) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
