17,382
社区成员




select count(*) into v_number form 表B
where id=v_id --用的游标来取表A的值
and name=v_name
and newtime between v_newtime - interval '10' minute and v_newtime;
if v_number=0 then
insert into 表B values(v_id,v_name,v_newtime,v_newtime);--情况一
else
update 表B set newtime=v_newtime
where id=v_id
and name=v_name
and newtime between v_newtime - interval '10' minute and v_newtime;--情况二