-- -- acs_sc_impl__get_id/2 -- create or replace function acs_sc_impl__get_id( character varying, character varying ) returns int4 as $$ declare p_impl_contract_name alias for $1; p_impl_name alias for $2; v_impl_id integer; begin select impl_id into v_impl_id from acs_sc_impls where impl_name = p_impl_name and impl_contract_name = p_impl_contract_name; return v_impl_id; end;$$ language plpgsql;