Index: openacs-4/contrib/packages/project-manager/tcl/project-manager-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/tcl/Attic/project-manager-procs-postgresql.xql,v
diff -u -r1.2.2.2 -r1.2.2.3
--- openacs-4/contrib/packages/project-manager/tcl/project-manager-procs-postgresql.xql	26 Oct 2004 01:22:27 -0000	1.2.2.2
+++ openacs-4/contrib/packages/project-manager/tcl/project-manager-procs-postgresql.xql	17 Dec 2004 23:06:26 -0000	1.2.2.3
@@ -38,7 +38,7 @@
 
   <fullquery name="pm::util::subsite_assignees_list_of_lists_not_cached.get_assignees">
     <querytext>
-      SELECT
+      SELECT DISTINCT
       p.first_names || ' ' || p.last_name as name,
       p.person_id
       FROM
@@ -50,8 +50,7 @@
       mr.rel_id = r.rel_id and
       p.person_id = r.object_id_two and
       member_state = 'approved'
-      ORDER BY
-      p.first_names, p.last_name
+      ORDER BY name
     </querytext>
   </fullquery>