Index: openacs-4/packages/acs-subsite/www/permissions/grant-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/permissions/Attic/grant-postgresql.xql,v
diff -u -r1.2 -r1.2.4.1
--- openacs-4/packages/acs-subsite/www/permissions/grant-postgresql.xql	30 Apr 2001 22:02:48 -0000	1.2
+++ openacs-4/packages/acs-subsite/www/permissions/grant-postgresql.xql	13 Mar 2003 14:05:33 -0000	1.2.4.1
@@ -13,8 +13,10 @@
 <fullquery name="parties">      
       <querytext>
       
-  select party_id, acs_object__name(party_id) as name
-  from parties
+  select p.party_id, 
+         acs_object__name(p.party_id)|| coalesce(' ('||p.email||')', '') as name
+  from   parties p
+  order  by name
 
       </querytext>
 </fullquery>