Function + BEFORE UPDATE trigger.
Define a PL/pgSQL function set_updated_at() that sets NEW.updated_at = now() and RETURNS TRIGGER, then attach a BEFORE UPDATE trigger on notes.
CREATE FUNCTION set_updated_at() RETURNS TRIGGER AS $$
BEGIN NEW.updated_at = now(); RETURN NEW; END;
$$ LANGUAGE plpgsql;
CREATE TRIGGER trg_notes_updated BEFORE UPDATE ON notes
FOR EACH ROW EXECUTE FUNCTION set_updated_at();
Sign in to save your code and track progress across devices.
