课程作业

1.创建带有入参和出参的函数1，调用函数时使用按参数值传递和命名标记法传参

CREATE FUNCTION fn1_test(a IN integer, b IN integer, c OUT integer)
RETURN integer
AS
BEGIN
   c := a + b;
END;
/
CALL fn1_test(1,2,0);
-- 使用命名标记法传参。
CALL fn1_test(a => 1,b => 3,c => 0);

2.创建返回类型为record的函数2，重命名函数2

CREATE OR REPLACE FUNCTION fn2_test(a int, out b bigint, out c bigint)
returns SETOF RECORD
as $$
begin
b = a + 1;
c = a * 10;
return next;
end;
$$language plpgsql;
call fn2_test(1, 0, 0);

alter function fn2_test(int) rename to fn2_test_1;

3.使用\sf和系统函数查看函数定义

\sf fn1_test
select * from pg_proc where proname = 'fn1_test';

4.删除函数

Drop function fn2_test_1;
Drop function fn1_test;