-- -- acs_sc_contract__delete/1 -- create or replace function acs_sc_contract__delete( integer ) returns int4 as $$ declare p_contract_id alias for $1; begin delete from acs_sc_contracts where contract_id = p_contract_id; return 0; end;$$ language plpgsql; -- -- acs_sc_contract__delete/1 -- create or replace function acs_sc_contract__delete( character varying ) returns int4 as $$ declare p_contract_name alias for $1; v_contract_id integer; begin v_contract_id := acs_sc_contract__get_id(p_contract_name); perform acs_sc_contract__delete(v_contract_id); return 0; end;$$ language plpgsql;