opengauss学习的第15天

#opengauss的第15天
1.创建带有入参和出参的函数1，调用函数时使用按参数值传递和命名标记法传参
omm=# create table item_example(c1 int, c2 int,c3 int,c4 int);
CREATE TABLE
omm=# create procedure procedure_insert_test(a int, b int,c int,d int)
omm-# as
omm# begin insert into item_example values(a, b,c,d); omm# end;
omm$# /
CREATE PROCEDURE
omm=# call procedure_insert_test(1,10,20,30)
procedure_insert

omm=# select * from item;
c1 | c2 |c3 | c4
----±------------
1 | 10 |20|30

2.创建返回类型为record的函数2，重命名函数2
omm=# CREATE OR REPLACE FUNCTION func_incr_sql_test(i int, out result_1 bigint, out result_result bigint) returns SETOF RECORD as $$
omm# begin omm# result_1 = i + 1;
omm# result_2 = i * 10; omm# return next;
omm# omm# end;

language plpgsql; CREATE FUNCTION omm=# call func_incr_sql_test(1, 0, 0); omm=# result_1 | result_2 ----------+---------- 2 | 10 **3.使用\sf和系统函数查看函数定义** omm=# \sf func_incr_sql_test CREATE OR REPLACE FUNCTION public.func_incr_sql_test(i integer, OUT result_1 bigint, OUT result_2 bigint) RETURNS SETOF record LANGUAGE plpgsql NOT FENCED NOT SHIPPABLE AS $function$ begin result_1 = i + 1; result_2 = i * 10; return next; end; $function$; **4.删除函数** drop function func_incr_sql_test; drop function procedure_insert_test;