Re: Group Query

From: Rob Kirkbride <rob(at)rkcomputing(dot)co(dot)uk>
To: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Group Query
Date: 2005-12-14 12:57:31
Message-ID: 43A016BB.6030605@rkcomputing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Achilleus Mantzios wrote:

>O Rob Kirkbride έγραψε στις Dec 14, 2005 :
>
>
>
>>Hi,
>>
>>It's probably because I'm struggling with array queries but how can I
>>get the (textual) list of groups allocated to the current user?
>>
>>I can get the current_user and extract the id out of pg_user, however I
>>need to then match this to an element as part of a list in pg_group,
>>this is the part I can't find how how to do. I'd like it as a ResultSet
>>with each element with the textual group name
>>
>>Thanks for any help,
>>
>>
>
>st=con.preparedStatement(select groname from pg_group where ?=any(grolist));
>st.setInt(1,uid);
>
>maybe?
>
>
Thanks thats better than my :-
select groname from pg_group where (array_to_string(grolist, 'x') ||
'x') like '%' || (select usesysid from pg_user where
usename=current_user) || 'x%'

I wasn't aware of the any operator!

Thanks a lot!

Rob

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Achilleus Mantzios 2005-12-14 13:43:37 Re: Group Query
Previous Message Rob Kirkbride 2005-12-14 11:00:48 Group Query