重庆思庄Oracle、Redhat认证学习论坛

标题: PG中查看过程函数定义的元命令\sf [打印本页]

作者: 郑全 时间: 2023-12-29 18:09
标题: PG中查看过程函数定义的元命令\sf

postgres@:5432/postgres-2865#=\sf student_delete_trigger
CREATE OR REPLACE FUNCTION public.student_delete_trigger()
RETURNS trigger
LANGUAGE plpgsql
AS $function$
begin
delete from score where student_no=old.student_no;
return old;
end;
$function$
postgres@:5432/postgres-2865#=

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)