创建函数自动更新修改字段

create or replace function update_timestamp() returns trigger as
$$
begin
new.update_date = current_timestamp;
new.updatedate = current_timestamp;
new.modify_date = current_timestamp;
return new;
end
$$
language plpgsql;