-- -- acs_sc_operation__delete/1 -- create or replace function acs_sc_operation__delete( integer ) returns int4 as $$ declare p_operation_id alias for $1; begin delete from acs_sc_operations where operation_id = p_operation_id; return 0; end;$$ language plpgsql; -- -- acs_sc_operation__delete/2 -- create or replace function acs_sc_operation__delete( character varying, character varying ) returns int4 as $$ declare p_contract_name alias for $1; p_operation_name alias for $2; v_operation_id integer; begin v_operation_id := acs_sc_operation__get_id( p_contract_name, p_operation_name ); perform acs_sc_operation__delete(v_operation_id); return v_operation_id; end;$$ language plpgsql;