tearf001
7/25/2018 - 7:07 AM

重命名,命名冲突

From https://www.postgresql.org/docs/10/static/plpgsql-declarations.html#PLPGSQL-DECLARATION-PARAMETERS

.sql
content_copyfile_download
result ALIAS FOR $0;

CREATE FUNCTION get_userid(username text) RETURNS int
AS $$
#print_strict_params on --打印参数

DECLARE
  userid int;
BEGIN
  SELECT users.userid INTO STRICT userid
   FROM users WHERE users.username = get_userid.username;
END;