Re: Could someone help me fix my array_list function? - Mailing list pgsql-sql

Michiel Lange wrote:
> Would the same work for pg_user and pg_group?
> 

See:
http://www.brasileiro.net:8080/postgres/cookbook/view-one-recipe.adp?recipe_id=11378

With these groups:
regression=# select * from pg_group; groname | grosysid |    grolist
---------+----------+--------------- grp1    |      100 | {100,101,102} grp2    |      101 | {100,102}
(2 rows)

Output looks like:
regression=# select * from groupview; grosysid | groname | usesysid | usename
----------+---------+----------+---------      100 | grp1    |      100 | user1      100 | grp1    |      101 | user2
  100 | grp1    |      102 | user3      101 | grp2    |      100 | user1      101 | grp2    |      102 | user3
 
(5 rows)

Joe