PGsql的触发器是先写一个函数:
比如说:
CREATE OR REPLACE FUNCTION "funUpdateGlobalInfoTableConfigureTS"()
RETURNS TRIGGER AS
$$
DECLARE
strSysTime TIMESTAMP;
sq interval;
BEGIN
SELECT INTO strSysTime localtimestamp(0);
SELECT INTO sq date_part('timezone_hour',current_timestamp)||'hours';
SELECT INTO strSysTime (strSysTime - sq );
UPDATE "GlobalInfoTable"
SET
"ConfigureTS" = strSysTime;
RETURN NULL;
END;
$$LANGUAGE plpgSQL;
然后在表上创建触发这个函数:
CREATE TRIGGER "triggerManageClientTableC"
AFTER INSERT OR UPDATE OR DELETE ON "ManageClientTable"
FOR EACH STATEMENT EXECUTE PROCEDURE "funUpdateGlobalInfoTableConfigureTS"();
在数据库本身做以我的理解好象是不可以