Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 039F0476DE0 for ; Mon, 20 Jan 2003 21:25:15 -0500 (EST) Received: from joeconway.com (unknown [63.210.180.150]) by postgresql.org (Postfix) with ESMTP id 0124D476E4C for ; Mon, 20 Jan 2003 20:47:16 -0500 (EST) Received: from [206.19.64.3] (account jconway HELO joeconway.com) by joeconway.com (CommuniGate Pro SMTP 4.0.4) with ESMTP-TLS id 1571218; Mon, 20 Jan 2003 18:21:29 -0800 Message-ID: <3E2CA648.3020600@joeconway.com> Date: Mon, 20 Jan 2003 17:45:44 -0800 From: Joe Conway User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Michiel Lange Cc: Guy Fraser , pgsql-sql@postgresql.org Subject: Re: Could someone help me fix my array_list function? References: <3E2C44F3.8010602@incentre.net> <3E2C44F3.8010602@incentre.net> <5.1.0.14.0.20030121013212.00b626f0@192.168.1.3> In-Reply-To: <5.1.0.14.0.20030121013212.00b626f0@192.168.1.3> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/310 X-Sequence-Number: 11175 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