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

declare
  upgrade__version_id             alias for $1;  
begin
    update apm_package_versions
    	set enabled_p = 'f',
	    installed_p = 'f'
	where package_key = (select package_key from apm_package_versions
	    	    	     where version_id = upgrade__version_id);
    update apm_package_versions
    	set enabled_p = 't',
	    installed_p = 't'
	where version_id = upgrade__version_id;			  
    
    return 0; 
end;$$ language plpgsql;