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

declare
  approve_email__user_id        alias for $1;  
begin
    update users
    set email_verified_p = 't'
    where user_id = approve_email__user_id;

    return 0; 
end;$$ language plpgsql;