-- -- acs_object__package_id/1 -- create or replace function acs_object__package_id( integer ) returns int4 as $$ declare p_object_id alias for $1; v_package_id acs_objects.package_id%TYPE; begin if p_object_id is null then return null; end if; select package_id into v_package_id from acs_objects where object_id = p_object_id; return v_package_id; end;$$ language plpgsql;