开发者社区 问答 正文

大家帮我看看 我编的pg函数 菜鸟?报错

CREATE OR REPLACE FUNCTION "Account_New"( 
IN LoginName char varying(50),
IN Password1 char varying(500),
IN DisplayName char varying(50),
IN ISuperAdmin bool,
IN Status integer,
IN Salt char varying(100),
IN AccountType integer,
IN Phone char varying(50),
IN Tel char varying(50),
IN Email char varying(500),
IN QQ char varying(50),
IN Gender int,
IN IDCode char varying(100),
IN Address char varying(200),
IN Remarks text,
IN CreatedBy bigint,
IN CreatedIp char varying(50)
)
returns void
AS
$BODY$


insert into "Account"("LoginName","Password","DisplayName","ISuperAdmin","Status","Salt","AccountType","Phone","Tel","Email","QQ","Gender","IDCode","Address","Remarks","CreatedBy","CreatedIp")
values($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17);


$BODY$
  LANGUAGE sql VOLATILE
  COST 100

  ROWS 1000;

为什么会报错啊ERROR:  ROWS is not applicable when function does not return a set

展开
收起
爱吃鱼的程序员 2020-06-22 13:59:22 355 分享 版权
1 条回答
写回答
取消 提交回答
  • https://developer.aliyun.com/profile/5yerqm5bn5yqg?spm=a2c6h.12873639.0.0.6eae304abcjaIB

    你里面的insert语句,少了个括号
    insertinto"Account"( )values();

    2020-06-22 13:59:41
    赞同 展开评论
问答分类:
问答地址: