pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Joe Conway <mail@joeconway.com>
To: Michiel Lange <michiel@minas.demon.nl>
Cc: Guy Fraser <guy@incentre.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Could someone help me fix my array_list function?
Date: Mon, 20 Jan 2003 17:45:44 -0800
Message-ID: <3E2CA648.3020600@joeconway.com> (raw)
In-Reply-To: <5.1.0.14.0.20030121013212.00b626f0@192.168.1.3>
References: <3E2C44F3.8010602@incentre.net>
	<3E2C44F3.8010602@incentre.net>
	<5.1.0.14.0.20030121013212.00b626f0@192.168.1.3>

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





view thread (4+ messages)

Message-ID: <3E2CA648.3020600@joeconway.com>
Permalink:  ../3E2CA648.3020600@joeconway.com/
Also on:    postgresql.org/message-id/3E2CA648.3020600@joeconway.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: mail@joeconway.com, michiel@minas.demon.nl, guy@incentre.net
  Subject: Re: Could someone help me fix my array_list function?
  In-Reply-To: <3E2CA648.3020600@joeconway.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox