All pastes #183942 Raw Edit

mysql_num_rows issue

public text v1 · immutable
#183942 ·published 2006-09-27 11:47 UTC
rendered paste body
CREATE OR REPLACE FUNCTION commit_log_update () RETURNS TRIGGER
AS '
BEGIN
   UPDATE latest_commits_ports
      SET commit_date = new.commit_date
    WHERE (latest_commits_ports.commit_log_id = new.id);

   UPDATE latest_commits
      SET commit_date = new.commit_date
    WHERE (latest_commits.commit_log_id = new.id);

   RETURN new;
END;'
LANGUAGE plpgsql;

  DROP TRIGGER commit_log_update on commit_log;
CREATE TRIGGER commit_log_update
AFTER UPDATE on commit_log
FOR EACH ROW
EXECUTE PROCEDURE commit_log_update ();