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
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 '
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