-- -- 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;