--
-- apm_package__highest_version/1
--
create or replace function apm_package__highest_version(
  character varying
) returns int4 as $$

declare
     highest_version__package_key    alias for $1;
     v_version_id                    apm_package_versions.version_id%TYPE;
begin
     select version_id into v_version_id
	from apm_package_version_info i 
	where apm_package_version__sortable_version_name(version_name) = 
             (select max(apm_package_version__sortable_version_name(v.version_name))
	             from apm_package_version_info v where v.package_key = highest_version__package_key)
	and package_key = highest_version__package_key;
      if NOT FOUND then 
         return 0;
      else
         return v_version_id;
      end if;
end;$$ language plpgsql;