Something

revver=# \df+ media_raw_on_update_trigger
                                                       List of functions
 Schema |            Name             | Result data type | Argument data types | Owner  | Language | Source code | Description 
--------+-----------------------------+------------------+---------------------+--------+----------+-------------+-------------
 public | media_raw_on_update_trigger | "trigger"        |                     | revver | plpgsql  | 
BEGIN
  NEW.status_update = OLD.status_update;
  IF OLD.status_update IS NULL THEN
    NEW.status_update = NULL;
    IF (OLD.status <> 1) AND (NEW.STATUS = 1) THEN
      NEW.status_update = NOW();
    END IF;
  END IF;
  RETURN NEW;
END;
            | 
(1 row)

revver=# \df+ media_raw_on_insert_trigger
                                                       List of functions
 Schema |            Name             | Result data type | Argument data types | Owner  | Language | Source code | Description 
--------+-----------------------------+------------------+---------------------+--------+----------+-------------+-------------
 public | media_raw_on_insert_trigger | "trigger"        |                     | revver | plpgsql  | 
BEGIN
  NEW.status_update = NULL;
  RETURN NEW;
END;
            | 
(1 row)