Groups

From: Kurt <rkdata(at)qwest(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Groups
Date: 2003-06-17 01:11:06
Message-ID: 1055812266.7666.11.camel@kschwarz.amoserve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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=-

Responses

  • Re: Groups at 2003-06-17 05:12:30 from Joe Conway

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-06-17 02:19:05 MIT Open Source Conference
Previous Message Tom Lane 2003-06-17 00:55:52 Re: order of nested loop