开发者社区> 问答> 正文

大家帮我看看 我编的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 299 0
1 条回答
写回答
取消 提交回答
  • https://developer.aliyun.com/profile/5yerqm5bn5yqg?spm=a2c6h.12873639.0.0.6eae304abcjaIB

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

    2020-06-22 13:59:41
    赞同 展开评论 打赏
问答分类:
问答地址:
问答排行榜
最热
最新

相关电子书

更多
PostgresChina2018_董红禹_SQL_Server迁移PG经验分享 立即下载
数据在PG中的升华 立即下载
低代码开发师(初级)实战教程 立即下载