--
-- acs_user__delete/1
--
create or replace function acs_user__delete(
  integer
) returns int4 as $$

declare
  delete__user_id       alias for $1;  
begin
  delete from user_preferences
  where user_id = delete__user_id;

  delete from users
  where user_id = delete__user_id;

  PERFORM person__delete(delete__user_id);

  return 0; 
end;$$ language plpgsql;