-- -- acs_object_type__pretty_name/1 -- create or replace function acs_object_type__pretty_name( character varying ) returns varchar as $$ declare pretty_name__object_type alias for $1; v_pretty_name acs_object_types.pretty_name%TYPE; begin select t.pretty_name into v_pretty_name from acs_object_types t where t.object_type = pretty_name__object_type; return v_pretty_name; end;$$ language plpgsql;