954
社区成员
发帖
与我相关
我的任务
分享
ss=# CREATE FUNCTION fun() RETURNS trigger AS $$
ss$# BEGIN
ss$# IF NEW.ColorNo IS NULL THEN
ss$# RAISE EXCEPTION 'ColorNo cannot be null';
ss$# END IF;
ss$# RETURN NULL;
ss$# END;
ss$# $$LANGUAGE plpgsql;
CREATE FUNCTION
ss=#ss=# CREATE FUNCTION fun() RETURNS trigger AS $$
ss$# BEGIN
ss$# IF NEW.ColorNo IS NULL THEN
ss$# RAISE EXCEPTION 'ColorNo cannot be null';
ss$# END IF;
ss$# END;
ss$# $$LANGUAGE plpgsql;
CREATE FUNCTION
ss=#
CREATE FUNCTION fun() RETURNS void AS
$BODY$
BEGIN
IF NEW.ColorNo IS NULL THEN
RAISE EXCEPTION 'ColorNo cannot be null';
END IF;
RETURN;
END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;