-- -- acs_sc_contract__get_id/1 -- create or replace function acs_sc_contract__get_id( character varying ) returns int4 as $$ declare p_contract_name alias for $1; v_contract_id integer; begin select contract_id into v_contract_id from acs_sc_contracts where contract_name = p_contract_name; return v_contract_id; end;$$ language plpgsql;