sql插入函数 [英] sql insert function
问题描述
文档中没有任何使用sql语言
函数进行插入的例子,我不知道我在这里做错了。
我尝试创建函数的错误是:错误:
或接近$ 1的语法错误在角色148
CREATE FUNCTION taxship(varchar,integer,varchar,float,float)返回整数
AS''
插入税务(s_oid,order_id,mer_id,tax,shipping)值
(''$ 1'',$ 2,''$ 3'',$ 4,$ 5);
SELECT 1;
''LANGUAGE SQL;
------------------------- - (广播结束)---------------------------
提示7:别忘了增加你的可用空间地图设置
1"在角色148
CREATE FUNCTION taxship(varchar,integer,varchar,float,float)返回整数
AS''
插入税务(s_oid,order_id,mer_id,tax,shipping)值
(''
1'',
< BLOCKQUOTE> 2 ''
The documentation doesn''t have any examples of using an sql language
function to do an insert, andI am at loss as to I am doing wrong here.
The error I get trying to create the function is: ERROR: syntax error at
or near "$1" at character 148
CREATE FUNCTION taxship(varchar,integer,varchar,float,float) returns integer
AS ''
insert into taxship(s_oid,order_id,mer_id,tax,shipping) values
(''$1'',$2,''$3'',$4,$5);
SELECT 1;
'' LANGUAGE SQL;
---------------------------(end of broadcast)---------------------------
TIP 7: don''t forget to increase your free space map settings
1" at character 148
CREATE FUNCTION taxship(varchar,integer,varchar,float,float) returns integer
AS ''
insert into taxship(s_oid,order_id,mer_id,tax,shipping) values
(''
1'',
2,''
这篇关于sql插入函数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!