Index: openacs-4/packages/acs-subsite/www/admin/group-types/one-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/group-types/one-postgresql.xql,v diff -u -N -r1.2 -r1.2.2.1 --- openacs-4/packages/acs-subsite/www/admin/group-types/one-postgresql.xql 4 Dec 2001 00:20:47 -0000 1.2 +++ openacs-4/packages/acs-subsite/www/admin/group-types/one-postgresql.xql 9 Mar 2002 22:18:27 -0000 1.2.2.1 @@ -6,7 +6,7 @@ - select my_view.group_name, my_view.group_id, 1 as num + select my_view.group_name, my_view.group_id from (select DISTINCT g.group_name, g.group_id from acs_objects o, groups g, application_group_element_map app_group,