合 PG 14新特性之存储过程支持out参数
Tags: PGPostgreSQL新特性存储过程PG 14
示例
1 2 3 4 5 6 | CREATE PROCEDURE insert_data(a integer, b integer) LANGUAGE SQL AS $$ INSERT INTO tbl VALUES (a); INSERT INTO tbl VALUES (b); $$; |
or
1 2 3 4 5 6 | CREATE PROCEDURE insert_data(a integer, b integer) LANGUAGE SQL BEGIN ATOMIC INSERT INTO tbl VALUES (a); INSERT INTO tbl VALUES (b); END; |