--
-- apm_package_version__remove_dependency/1
--
create or replace function apm_package_version__remove_dependency(
  integer
) returns int4 as $$

declare
  remove_dependency__dependency_id          alias for $1;  
begin
    delete from apm_package_dependencies 
    where dependency_id = remove_dependency__dependency_id;

    return 0; 
end;$$ language plpgsql;


--
-- apm_package_version__remove_dependency/3
--
create or replace function apm_package_version__remove_dependency(
  character varying,
  character varying,
  integer
) returns int4 as $$

declare
  remove_dependency__dependency_uri         alias for $1;  
  remove_dependency__dependency_version     alias for $2;  
  remove_dependency__version_id             alias for $3;  
  v_dep_id                           apm_package_dependencies.dependency_id%TYPE;
begin
      select dependency_id into v_dep_id from apm_package_dependencies 
      where service_uri = remove_dependency__dependency_uri 
      and service_version = remove_dependency__dependency_version;
      PERFORM apm_package_version__remove_dependency(v_dep_id);

      return 0; 
end;$$ language plpgsql;