在PG里面函数,用户自定义的函数有四种类型:
- query language functions (functions written in SQL) (Section 37.5)
- procedural language functions (functions written in, for example,PL/pgSQL or PL/Tcl) (Section 37.8)
- internal functions (Section 37.9)
- C-language functions (Section 37.10)
本文只介绍前两种类型。
定义函数
语法
参考这里:https://www.postgresql.org/docs/current/sql-createfunction.html
CREATE [ OR REPLACE ] FUNCTION
name ( [ [ argmode ] [ argname ] argtype [ { DEFAULT | = } default_expr ] [, ...] ] )
[ RETURNS rettype
| RETURNS TABLE