一、存储过程
CREATE FUNCTION del_ref (per_size INT) RETURNS void AS $$
DECLARE
ref_id record ;
mid_count int;
BEGIN
FOR ref_id IN EXECUTE 'SELECT id FROM cdr_reference limit '||$1 loop
SELECT INTO mid_count count(id) FROM resource_reference_index WHERE reference_id=ref_id.id;
if mid_count=0 THEN