for php to Postgres FOR循环

<?php
// 连接到PostgreSQL数据库
$conn = pg_connect("host=localhost dbname=mydb user=myuser password=mypassword");

// 查询数据
$result = pg_query($conn, "SELECT * FROM mytable");

// 使用for循环遍历查询结果
for ($i = 0; $i < pg_num_rows($result); $i++) {
    $row = pg_fetch_assoc($result, $i);
    // 执行操作，例如打印每行数据
    echo "ID: " . $row['id'] . ", Name: " . $row['name'] . "<br>";
}

// 关闭数据库连接
pg_close($conn);
?>

CREATE OR REPLACE FUNCTION my_function()
RETURNS VOID AS $$
DECLARE
    i INT;
BEGIN
    FOR i IN 1..10 LOOP
        -- 执行操作，例如插入数据
        INSERT INTO mytable (id, name) VALUES (i, 'Name ' || i);
    END LOOP;
END;
$$ LANGUAGE plpgsql;

SELECT my_function();