deploy/update_timestamp.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

-- Deploy kakeibo:update_timestamp to pg
-- requires: appschema

BEGIN;

CREATE OR REPLACE FUNCTION kakeibo.update_timestamp()
  RETURNS TRIGGER AS $$
BEGIN
  NEW.updated_at = NOW();
  RETURN NEW;
END;
$$ LANGUAGE plpgsql;

COMMIT;