Re: mapping user name to group name

> On Monday 10 Mar 2003 5:47 pm, Matthew Phillips wrote:
>>
>> to map a user name to
>> the group name
>> has its own usesysids within an array of integers. I have no clue how
>> to search within an array using a select statement.
>
> there
> are  some array-handling functions in contrib/intarray
>


SELECT
 pg_group.groname,
 pg_user.usename
FROM pg_user, pg_group
WHERE (pg_group.grolist *= pg_user.usesysid)
ORDER BY pg_group.groname, pg_user.usename;

works for me, after installing the array-handing functions referred to by
Huxton.

~Berend Tober