先看基本的语法:
NameCREATE FUNCTION
CREATE [ OR REPLACE ] FUNCTION
name( [ [argmode] [argname]argtype[ { DEFAULT | = }default_expr] [, ...] ] )
[ RETURNSrettype
| RETURNS TABLE (column_namecolumn_type[, ...] ) ]
{ LANGUAGElang_name
| WINDOW
| IMMUTABLE | STABLE | VOLATILE
| CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT
| [ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER
| COSTexecution_cost
| ROWSresult_rows
| SETconfiguration_parameter{ TOvalue| =value| FROM CURRENT }
| AS 'definition'
| AS 'obj_file', 'link_symbol'