migrations/001_create_timestamp_trigger.sql


1
2
3
4
5
6
7
8
9
10
11

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

---- create above / drop below ----

DROP FUNCTION trigger_set_timestamp();