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.7 -r1.7.2.1
--- openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql	9 Aug 2002 20:02:27 -0000	1.7
+++ openacs-4/packages/acs-tcl/tcl/community-core-procs-postgresql.xql	25 Jun 2003 09:23:46 -0000	1.7.2.1
@@ -35,4 +35,16 @@
       </querytext>
 </fullquery>
 
+<fullquery name="user_search">
+  <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 || ' ', '')  ||
+             coalesce(u.last_name || ' ', '') ||
+             u.email || ' ' ||
+             coalesce(u.screen_name, '')) like upper('%'||:value||'%')
+      order  by name
+  </querytext>
+</fullquery>
+
 </queryset>