命名参数

最近更新时间: 2025-10-11 18:10:00

postgres=# CREATE OR REPLACE PROCEDURE p_name(a_xm text) AS
$$
BEGIN
     raise notice '$1=%',a_xm;
END;
$$
LANGUAGE PLPGSQL;
CREATE PROCEDURE
postgres=# call p_name('Tbase');
NOTICE:  $1=Tbase
CALL
postgres=#