CASE语句
最近更新时间: 2025-02-18 16:02:00
postgres=# CREATE OR REPLACE PROCEDURE p_case() AS
$$
DECLARE
v_float8 float8 := random();
BEGIN
CASE
WHEN v_float8>0.99 THEN
RAISE NOTICE '随机数大于0.99';
WHEN v_float8>0.5 THEN
RAISE NOTICE '随机数大于0.50';
WHEN v_float8>0.25 THEN
RAISE NOTICE '随机数大于0.25';
ELSE
RAISE NOTICE '随机数小于或等于0.25';
END CASE;
END;
$$
LANGUAGE plpgsql;
CREATE PROCEDURE
postgres=# CALL p_case();
NOTICE: 随机数小于或等于0.25
CALL
postgres=#