-- -- acs_object__default_name/1 -- create or replace function acs_object__default_name( integer ) returns varchar as $$ declare default_name__object_id alias for $1; object_type_pretty_name acs_object_types.pretty_name%TYPE; begin select ot.pretty_name into object_type_pretty_name from acs_objects o, acs_object_types ot where o.object_id = default_name__object_id and o.object_type = ot.object_type; return object_type_pretty_name || ' ' || default_name__object_id; end;$$ language plpgsql;