Index: openacs-4/packages/bug-tracker/www/admin/project-edit-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/bug-tracker/www/admin/Attic/project-edit-postgresql.xql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/bug-tracker/www/admin/project-edit-postgresql.xql 5 Mar 2003 18:14:15 -0000 1.1.2.1 +++ openacs-4/packages/bug-tracker/www/admin/project-edit-postgresql.xql 20 Mar 2003 16:28:27 -0000 1.1.2.2 @@ -3,15 +3,15 @@ postgresql7.1 - + - 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 + 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