IF...THEN...ELSE...END IF
最近更新时间: 2025-02-18 16:02:00
postgres=# CREATE OR REPLACE PROCEDURE p_if_else() AS
$$
BEGIN
IF random()>0.99 THEN
RAISE NOTICE '随机数大于0.99';
ELSE
RAISE NOTICE '随机数小于或等于0.99';
END IF;
END;
$$
LANGUAGE plpgsql;
CREATE PROCEDURE
postgres=# CALL p_if_else();
NOTICE: 随机数小于或等于0.99
CALL
postgres=#