-- Deploy kakeibo:update_timestamp to pg -- requires: schema BEGIN; CREATE OR REPLACE FUNCTION kakeibo.update_timestamp() RETURNS TRIGGER AS $$ BEGIN NEW.updated_at = NOW(); RETURN NEW; END; $$ LANGUAGE plpgsql; COMMIT;
index : life-archive-schema.git | ||
Sqitch: 私生活用 DB のマイグレーション管理. | Masaya Tojo |
aboutsummaryrefslogtreecommitdiff |
-- Deploy kakeibo:update_timestamp to pg -- requires: schema BEGIN; CREATE OR REPLACE FUNCTION kakeibo.update_timestamp() RETURNS TRIGGER AS $$ BEGIN NEW.updated_at = NOW(); RETURN NEW; END; $$ LANGUAGE plpgsql; COMMIT;