postgresql7.1 select acs__add_user( :user_id, 'user', now(), null, :peeraddr, null, -- authority :username, :email, :url, :first_names, :last_name, :hashed_password, :salt, null, :email_verified_p, :member_state ); select acs_user__delete(:user_id); select person__delete(:person_id); 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