Re: Group Query

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?
>
> Rob
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

--
-Achilleus