postgre创建存储过程_如何在Postgresql中编写更新函数(存储过程)？

您可以在PGXN网站的源代码中找到这类内容的优秀示例：

用户sql文件的示例：

CREATE OR REPLACE FUNCTION update_user(

nickname LABEL,

full_name TEXT DEFAULT NULL,

email EMAIL DEFAULT NULL,

uri URI DEFAULT NULL,

twitter CITEXT DEFAULT NULL

) RETURNS BOOLEAN LANGUAGE plpgsql SECURITY DEFINER AS $$

/*

% SELECT update_user(

nickname := 'theory',

full_name := 'David E. Wheeler',

email := 'justatheory@pgxn.org',

uri := 'http://www.justatheory.com/',

twitter :- 'theory'

);

update_user

─────────────

t

Update the specified user. The user must be active. The nickname cannot be

changed. The password can only be changed via `change_password()` or

`reset_password()`. Pass other attributes as:

full_name

<