|
|
相关文章推荐
PostgreSQL中"IF“处或附近的语法错误
问
PostgreSQL中"IF“处或附近的语法错误
EN
Stack Overflow用户
提问于
2022-01-07 16:05:06
回答 1
查看 133
关注 0
票数 0
我试图在PostgreSQL上编写一个sql函数，但是在‘IF’上有一个错误：
ERROR: Syntax error at or near "IF"
LINE 11: IF Type = 's' THEN我不明白语法错误。
(没有IF正确工作的函数)
我的SQL代码：
CREATE OR REPLACE FUNCTION public.add_activity(IDactivity smallint,Date_Start date, Data_End date,
Type character varying,Name character varying DEFAULT NULL::character varying,
Typology character varying DEFAULT NULL::character varying, Client smallint DEFAULT NULL::smallint)
RETURNS void
LANGUAGE 'sql'
AS $BODY$
INSERT INTO public."Activity"
VALUES(IDactivity, Date_Start, Data_End, Type, Name);
IF Type = 's' THEN
INSERT INTO public."Service"
VALUES(IDactivity, Typology, Client);
END IF;
$BODY$;谢谢!
EN
回答 1
Stack Overflow用户
回答已采纳
发布于 2022-01-07 16:23:20
IF
不是用
sql
语言实现的，而是用
plpgsql
语言实现的，参见
手册
。
您可以将
LANGUAGE sql
替换为
LANGUAGE plpgsql
，然后在函数体中添加
BEGIN
和
END
：
CREATE OR REPLACE FUNCTION public.add_activity(IDactivity smallint,Date_Start date, Data_End date,
Type character varying,Name character varying DEFAULT NULL::character varying,
Typology character varying DEFAULT NULL::character varying, Client smallint DEFAULT NULL::smallint)
RETURNS void
LANGUAGE plpgsql
AS $BODY$
BEGIN
INSERT INTO public."Activity"
VALUES(IDactivity, Date_Start, Data_End, Type, Name);
IF Type = 's' THEN
INSERT INTO public."Service"
VALUES(IDactivity, Typology, Client);
END IF;
END ;
$BODY$
或者您可以更改代码以保留
sql
语言：
CREATE OR REPLACE FUNCTION public.add_activity(IDactivity smallint,Date_Start date, Data_End date,
Type character varying,Name character varying DEFAULT NULL::character varying,
Typology character varying DEFAULT NULL::character varying, Client smallint DEFAULT NULL::smallint)
RETURNS void
LANGUAGE sql
AS $BODY$
INSERT INTO public."Activity"
VALUES(IDactivity, Date_Start, Data_End, Type, Name);
推荐文章