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