postgres循环操作语句备忘

2023-05-04  本文已影响0人  佚可
DO $FN$
BEGIN
  FOR counter IN 279657450..315422529 LOOP
    RAISE NOTICE 'Counter: %', counter;
    EXECUTE $$ delete from xxxx_table where id=$1 $$ 
      USING counter;
  END LOOP;
END;
$FN$
上一篇 下一篇

猜你喜欢

热点阅读