-- -- 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;