DO
$$
DECLARE
record_count INTEGER;
BEGIN
-- 检查goods表中是否存在name为泽的记录
-- 正常状态且是dms任务单据的数量是0,那就执行插入脚本,否则不执行插入脚本
SELECT COUNT(*) INTO record_count FROM goods WHERE name = '泽' and "storage"=100;
-- 如果不存在name为泽的记录(即count为0)
IF record_count = 0 THEN
-- 插入到goods表
INSERT INTO public.goods
(id, "name", "storage", goodstype, count, remark, target_value, target_value_string, target_big)
VALUES(1012, '泽1', 100, NULL, NULL, '泽不存在就插入1', 100.000000, '100.000', 10.150000);
-- 插入到worker表
INSERT INTO public.worker
(id, "name", work_number, phone, email , age)
VALUES('6', '曲端1', '102', '124', '124@qq.com', 19);
INSERT INTO public.worker
(id, "name", work_number, phone, email, age)
VALUES('7', '李延年1', '103', '125', '125@qq.com', 20);
END IF;
END
$$
;
pgsql的if语句使用
于 2024-06-26 21:56:48 首次发布