Blackboard Transact Unix - PostgreSQL Triggers

gistfile1.sql

-- Create a function to preform the timestamp update.
CREATE OR REPLACE FUNCTION update_updated_at_column()
  RETURNS TRIGGER AS $$
  BEGIN
    NEW.updated_at = now(); 
    RETURN NEW;
  END;
  $$ language 'plpgsql';

-- Create a trigger to run this function prior to an UPDATE on a row.
CREATE TRIGGER update_vidimg_updated_at_time BEFORE UPDATE ON vidimg FOR EACH ROW EXECUTE PROCEDURE update_updated_at_column();