[摘要]''mins'');insert into co_schedule values(prog_id,ins_starttime,ins_endtime);i := i+...
''mins'');
insert into co_schedule values(prog_id,ins_starttime,ins_endtime);
i := i+1;
end loop;
if i<repeat_times then
return false;
else
return true;
end if;
end;
'language 'plpgsql';
//执行函数:
select add_program_time(1,'2002-10-20 0:0:0','5','60','5');
//查看结果:select * from co_schedule;
n_progid
关键词:一个PostgreSQL存储过程的例子: