基于YOLOv8-pose的画笔关键点（bic_markers）检测

FOR row_data IN select * from pm_bic_azgl_d04700_rel where xmid = code and not EXISTS(select 1 from pm_bic_azgl_d04700_dev dev where dev.id = id ) ORDER BY doc_date ASC LOOP -- 如果货方数已经减为0，则退出循环 -- EXIT WHEN remaining_quantity <= 0; -- 计算当前记录的可减少货方数 DECLARE available_quantity numeric(20,2) := LEAST(remaining_quantity, row_data.lsje); BEGIN RAISE NOTICE '当前剩余贷方数总量: %', remaining_quantity; --更新记录 -- update pm_bic_azgl_d04700_rel -- set lsje = lsje - available_quantity -- where id = row_data.id; -- 写入借贷冲销结果至结果表 INSERT INTO pm_bic_azgl_d04700_dev (id, xmid, doc_date, lsje, hkje, days) VALUES (row_data.id, row_data.xmid, row_data.doc_date, row_data.lsje - available_quantity, row_data.hkje, row_data.days); -- 更新剩余货方数 remaining_quantity := remaining_quantity - available_quantity; END; END LOOP;