Index: openacs-4/packages/acs-subsite/www/members/member-invite-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/members/Attic/member-invite-postgresql.xql,v diff -u -N --- openacs-4/packages/acs-subsite/www/members/member-invite-postgresql.xql 26 Jan 2004 15:39:46 -0000 1.3 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,24 +0,0 @@ - - - - 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||'%') - and not exists (select 1 from acs_rels where object_id_one = $group_id and object_id_two = u.user_id and rel_type = 'membership_rel') - order by name - - - - - - - - -