命名参数

最近更新时间: 2025-02-18 16:02: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=#