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

declare
  role_pretty_plural__role      alias for $1;  
  v_pretty_plural               acs_rel_roles.pretty_plural%TYPE;
begin
    select r.pretty_plural into v_pretty_plural
      from acs_rel_roles r
     where r.role = role_pretty_plural__role;

    return v_pretty_plural;
   
end;$$ language plpgsql;