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