--
-- acs_rel_type__role_pretty_name/1
--
create or replace function acs_rel_type__role_pretty_name(
  character varying
) returns varchar as $$

declare
  role_pretty_name__role        alias for $1;  
  v_pretty_name                 acs_rel_roles.pretty_name%TYPE;
begin
    select r.pretty_name into v_pretty_name
      from acs_rel_roles r
     where r.role = role_pretty_name__role;

    return v_pretty_name;
   
end;$$ language plpgsql;