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

declare
        num_instances__package_key     alias for $1;
        v_num_instances                integer;
begin
        select count(*) into v_num_instances
	from apm_packages
	where package_key = num_instances__package_key;

        return v_num_instances;

end;$$ language plpgsql;