-- トリガ関数
  CREATE OR REPLACE FUNCTION db_test."MSTW000010_insert"() RETURNS trigger AS
  $BODY$BEGIN
 	NEW.CA := to_char(current_timestamp,'YYYYMMDD');
 	NEW.CB := to_char(current_timestamp,'HH24MISS');
  RETURN NEW;
  END;
  BODY$
   LANGUAGE plpgsql VOLATILE
   COST 100;
  ALTER FUNCTION db_test."MSTW000010_insert"()
   OWNER TO postgres;
 
  CREATE OR REPLACE FUNCTION db_test."MSTW000010_update"() RETURNS trigger AS
  $BODY$BEGIN
 	NEW.CC := to_char(current_timestamp,'YYYYMMDD');
 	NEW.CD := to_char(current_timestamp,'HHMISS');
  RETURN NEW;
  END;
  $BODY$
   LANGUAGE plpgsql VOLATILE
   COST 100;
  ALTER FUNCTION db_test."MSTW000010_update"()
   OWNER TO postgres;
 
  --- Insert Before トリガ
  CREATE TRIGGER "TBI_MSTW000010"
   BEFORE INSERT
   ON db_test.mstw000010
   FOR EACH ROW
   EXECUTE PROCEDURE db_test."MSTW000010_insert"();
 
  --- Update Before トリガ
  CREATE TRIGGER "TBU_MSTW000010"
   BEFORE UPDATE
   ON db_test.mstw000010
   FOR EACH ROW
   EXECUTE PROCEDURE db_test."MSTW000010_update"();