CREATE FUNCTION user_stamp () RETURNS trigger AS $user_stamp$
BEGIN
NEW.lastupdate := 'now';
RETURN NEW;
END;
$user_stamp$ LANGUAGE plpgsql;
CREATE TRIGGER user_stamp BEFORE INSERT OR UPDATE ON fb_fy_user
FOR EACH ROW EXECUTE PROCEDURE user_stamp();
ALTER FUNCTION user_stamp() OWNER TO postgres;
GRANT ALL ON FUNCTION user_stamp() TO adchap_test;
BEGIN
NEW.lastupdate := 'now';
RETURN NEW;
END;
$user_stamp$ LANGUAGE plpgsql;
CREATE TRIGGER user_stamp BEFORE INSERT OR UPDATE ON fb_fy_user
FOR EACH ROW EXECUTE PROCEDURE user_stamp();
ALTER FUNCTION user_stamp() OWNER TO postgres;
GRANT ALL ON FUNCTION user_stamp() TO adchap_test;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29753604/viewspace-1390872/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
