云数据库 GaussDB-分支语句:示例

时间：2023-11-01 16:22:24

云数据库 GaussDB

示例

  
       CREATE OR REPLACE PROCEDURE proc_case_branch(pi_result in integer, pi_return out integer)AS     BEGIN         CASE pi_result             WHEN 1 THEN                 pi_return := 111;             WHEN 2 THEN                 pi_return := 222;             WHEN 3 THEN                 pi_return := 333;             WHEN 6 THEN                 pi_return := 444;             WHEN 7 THEN                 pi_return := 555;             WHEN 8 THEN                 pi_return := 666;             WHEN 9 THEN                 pi_return := 777;             WHEN 10 THEN                 pi_return := 888;             ELSE                 pi_return := 999;         END CASE;         raise info 'pi_return : %',pi_return ; END; /CALL proc_case_branch(3,0);--删除存储过程DROP PROCEDURE proc_case_branch;