Index: openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql,v
diff -u -r1.17 -r1.18
--- openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql	1 Nov 2003 10:46:32 -0000	1.17
+++ openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql	11 Dec 2003 21:39:56 -0000	1.18
@@ -46,10 +46,10 @@
   <querytext>
       select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id
       from   cc_users u
-      where  upper(coalesce(u.first_names || ' ', '')  ||
+      where  lower(coalesce(u.first_names || ' ', '')  ||
              coalesce(u.last_name || ' ', '') ||
              u.email || ' ' ||
-             coalesce(u.screen_name, '')) like upper('%'||:value||'%')
+             coalesce(u.screen_name, '')) like lower('%'||:value||'%')
       order  by name
   </querytext>
 </fullquery>
@@ -122,7 +122,7 @@
                  creation_ip
           from   cc_users 
           where  authority_id = :authority_id
-          and    upper(username) = upper(:username)
+          and    lower(username) = lower(:username)
 
       </querytext>
 </fullquery>