更新日期:2024年09月11日
下列 CREATE FUNCTION 语句创建读取客户地址的例程:
CREATE FUNCTION read_address (lastname CHAR(15)) -- one argument
RETURNING CHAR(15), CHAR(15), CHAR(20), CHAR(15),CHAR(2)
CHAR(5); -- 6 items
DEFINE p_lname,p_fname, p_city CHAR(15);
--define each routine variable
DEFINE p_add CHAR(20);
DEFINE p_state CHAR(2);
DEFINE p_zip CHAR(5);
SELECT fname, address1, city, state, zipcode
INTO p_fname, p_add, p_city, p_state, p_zip
FROM customer
WHERE lname = lastname;
RETURN p_fname, lastname, p_add, p_city, p_state, p_zip;
--6 items
END FUNCTION;
DOCUMENT 'This routine takes the last name of a customer as',
--brief description
'its only argument. It returns the full name and address',
'of the customer.'
WITH LISTING IN 'pathname' -- modify this pathname according
-- to the conventions that your operating system requires
-- compile-time warnings go here
; -- end of the routine read_address
下表列举了GBase 8c 中支持的扩展函数,不作为商用特性交付,仅供参考。
分类
函数名称
描述
访问权
限查询
函数
has_sequence_privilege(user,
sequence, privilege)
指定用户是否有访问序列的权限
has_sequence_privilege(sequence,
privilege)
当前用户是否有访问序列的权限
GBase 8c SQL 参考手册
南大通用数据技术股份有限公司
1287
分类
函数名称
描述
触发器
函数
pg_get_triggerdef(oid)
为触发器获取CREATE [ CONSTRAINT ]
TRIGGER 命令
pg_get_triggerdef(oid, boolean)
为触发器获取CREATE [ CONSTRAINT ]
TRIGGER 命令