postgresql - Postgres : Using function variable names in pgsql function

Question

我已经按照下面显示的内容编写了一个 pgsql 函数。如何去掉 $1、$2 等并将它们替换为真正的参数名称以使函数代码更具可读性？

问候

彼得

CREATE OR REPLACE FUNCTION InsertUser (
    UserID UUID,
    FirstName CHAR(10),
    Surname VARCHAR(75),
    Email VARCHAR(75)
)
RETURNS void
AS
$$
INSERT INTO "User" (userid,firstname,surname,email)
VALUES ($1,$2,$3,$4)
$$
LANGUAGE SQL;

Answer 1

使用前必须先在申报区申报。例如:

DECLARE   
    v_UserID alias for $1;
    v_FirstName alias for $2;
    v_Surname alias for $3;
    v_Email alias for $4;
BEGIN
$$
END