Groups - Mailing list pgsql-general

From Kurt
Subject Groups
Date
Msg-id 1055812266.7666.11.camel@kschwarz.amoserve.net
Whole thread Raw
Responses Re: Groups  (Joe Conway <mail@joeconway.com>)
List pgsql-general
I'm trying to extract all the groups to which a user belongs from
pg_group.

Being that arrays are not my forte, I'm getting frustrated trying to get
it to work.  It seems that I can extract the proper group if the user
happens to be in a certain position in the array, but if that person is
not, it will not show up in the query.

Where am I going wrong?  How do I find all the groups to which a user
belongs no matter the number of users in any particular group?

Hope this makes sense.

            -=Kurt=-


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: order of nested loop
Next
From: Bruce Momjian
Date:
Subject: MIT Open Source Conference