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

时间：2025-02-12 15:05:43

云数据库 GaussDB

示例

  
       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; /CREATE PROCEDUREgaussdb=# CALL proc_case_branch(3,0);INFO:  pi_return : 333 pi_return -----------       333(1 row)--删除存储过程gaussdb=# DROP PROCEDURE proc_case_branch;DROP PROCEDURE