Re: [ADMIN] pg_group view

2002-12-30 Thread Joe Conway
Oliver Elphick wrote: WHERE grosysid = rec.grosysid; Thanks, nice catch! You exposed my lack of adequate testing. I guess I should have added a disclaimer ;-) Joe ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, p

Re: [ADMIN] pg_group view

2002-12-30 Thread Oliver Elphick
On Mon, 2002-12-30 at 22:16, Joe Conway wrote: > Rob Abernethy IV wrote: > > Does anyone have a good recipe for a view that will display users/gruops in a > > way that can be used with Tomcat's JDBCRelam configuration? ... > CREATE OR REPLACE FUNCTION expand_groups() RETURNS SETOF group_view AS '

Re: [ADMIN] pg_group view

2002-12-30 Thread Joe Conway
Rob Abernethy IV wrote: Does anyone have a good recipe for a view that will display users/gruops in a way that can be used with Tomcat's JDBCRelam configuration? In other words, instead of seeing a *list* of users in a group (grolist), I'd like to see a separate row for every group/user combinati