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$
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$