– Automatically update date columns CREATE OR REPLACE FUNCTION framework.trf_created_at_and_updated_at() RETURNS TRIGGER AS $$ BEGIN
IF (TG_OP = 'INSERT') THEN NEW.created_at = now(); END IF; NEW.updated_at = now(); RETURN NEW;
END; $$ LANGUAGE plpgsql;