17 lines
369 B
PL/PgSQL
17 lines
369 B
PL/PgSQL
-- v2: add trigger to keep updated_at in sync
|
|
CREATE OR REPLACE FUNCTION touch_updated_at()
|
|
RETURNS TRIGGER AS $$
|
|
BEGIN
|
|
NEW.updated_at = NOW();
|
|
RETURN NEW;
|
|
END;
|
|
$$ LANGUAGE plpgsql;
|
|
|
|
DROP TRIGGER IF EXISTS trg_touch_tarifs_updated_at ON tarifs;
|
|
CREATE TRIGGER trg_touch_tarifs_updated_at
|
|
BEFORE UPDATE ON tarifs
|
|
FOR EACH ROW
|
|
EXECUTE PROCEDURE touch_updated_at();
|
|
|
|
|