Batch updating fields

You must execute the code again to save those values in the database.

DO $$
DECLARE
    batch_size INT := 10000; -- Define the batch size
    offset INT := 0; -- Initialize offset for pagination
    rows_updated INT; -- Variable to store the number of rows updated
BEGIN
    LOOP
        -- Update the rows in batches of 10,000
        WITH updated_rows AS (
            UPDATE unclaimed_property
            SET 
                Address_Normalization_Progress = 'Invalid Addresses Deleted',
                "owner_address_line_1-cleaned" = CASE 
                    WHEN "owner_address_line_1-cleaned" !~ '[0-9]' THEN NULL 
                    ELSE "owner_address_line_1-cleaned" 
                END,
                "owner_address_line_2-cleaned" = CASE 
                    WHEN "owner_address_line_2-cleaned" !~ '[0-9]' THEN NULL 
                    ELSE "owner_address_line_2-cleaned" 
                END,
                "owner_address_line_3-cleaned" = CASE 
                    WHEN "owner_address_line_3-cleaned" !~ '[0-9]' THEN NULL 
                    ELSE "owner_address_line_3-cleaned" 
                END
            WHERE 
                Address_Normalization_Progress = 'Not Normalized'
            LIMIT batch_size
            RETURNING *
        )
        SELECT COUNT(*) INTO rows_updated FROM updated_rows; -- Count updated rows

-- If no rows were updated, exit the loop
        EXIT WHEN rows_updated = 0;

-- Wait for 1 second before processing the next batch (if supported)
        PERFORM pg_sleep(1);

-- Increment the offset for the next batch
        offset := offset + batch_size;
    END LOOP;
END $$;

psql:queries.sql:41: ERROR: syntax error at or near "LIMIT" LINE 27: LIMIT batch_size ^