postgresql7.1 select acs__add_user( :user_id, 'user', now(), null, :peeraddr, :authority_id, :username, :email, :url, :first_names, :last_name, :hashed_password, :salt, :screen_name, :email_verified_p, :member_state ); select acs__remove_user(:user_id); select person__delete(:person_id); select distinct u.first_names || ' ' || u.last_name || ' (' || u.email || ')' as name, u.user_id from acs_users_all u where lower(coalesce(u.first_names || ' ', '') || coalesce(u.last_name || ' ', '') || u.email || ' ' || coalesce(u.screen_name, '')) like lower('%'||:value||'%') order by name select user_id, username, authority_id, first_names, last_name, first_names || ' ' || last_name as name, email, url, screen_name, priv_name, priv_email, email_verified_p, email_bouncing_p, no_alerts_until, last_visit, to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit_ansi, second_to_last_visit, to_char(second_to_last_visit, 'YYYY-MM-DD HH24:MI:SS') as second_to_last_visit_ansi, n_sessions, password_question, password_answer, password_changed_date, member_state, rel_id, trunc(date_part('epoch', age(password_changed_date))/(60*60*24)) as password_age_days, creation_date, creation_ip from cc_users where user_id = :user_id select user_id, username, authority_id, first_names, last_name, first_names || ' ' || last_name as name, email, url, screen_name, priv_name, priv_email, email_verified_p, email_bouncing_p, no_alerts_until, last_visit, to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit_ansi, second_to_last_visit, to_char(second_to_last_visit, 'YYYY-MM-DD HH24:MI:SS') as second_to_last_visit_ansi, n_sessions, password_question, password_answer, password_changed_date, member_state, rel_id, trunc(date_part('epoch', age(password_changed_date))/(60*60*24)) as password_age_days, creation_date, creation_ip from cc_users where authority_id = :authority_id and lower(username) = lower(:username)