> 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