array ( 0 => 'index.php', 1 => 'PHP Manual', ), 'head' => array ( 0 => 'UTF-8', 1 => 'zh', ), 'this' => array ( 0 => 'function.pg-set-chunked-rows-size.php', 1 => 'pg_set_chunked_rows_size', 2 => 'Set the query results to be retrieved in chunk mode', ), 'up' => array ( 0 => 'ref.pgsql.php', 1 => 'PostgreSQL 函数', ), 'prev' => array ( 0 => 'function.pg-send-query-params.php', 1 => 'pg_send_query_params', ), 'next' => array ( 0 => 'function.pg-set-client-encoding.php', 1 => 'pg_set_client_encoding', ), 'alternatives' => array ( ), 'source' => array ( 'lang' => 'en', 'path' => 'reference/pgsql/functions/pg-set-chunked-rows-size.xml', ), 'history' => array ( ), ); $setup["toc"] = $TOC; $setup["toc_deprecated"] = $TOC_DEPRECATED; $setup["parents"] = $PARENTS; manual_setup($setup); contributors($setup); ?>

pg_set_chunked_rows_size

(PHP 8 >= 8.4.0)

pg_set_chunked_rows_size — Set the query results to be retrieved in chunk mode

说明

pg_set_chunked_rows_size(PgSql\Connection $connection, int $size): bool

Set the query results to be retrieved in chunk mode. The query results returned afterward will be divided into multiple chunks, each containing up to size rows. This function must be called before retrieving results with pg_get_result(). This function is only available when libpq is version 17 or higher.

参数

connection

PgSql\Connection 实例。

size
The number of rows to be retrieved in each chunk.

返回值

成功时返回 true， 或者在失败时返回 false。

错误／异常

If size is less than 1, a ValueError will be thrown.

示例

示例 #1 pg_result_memory_size() example

<?php

$conn = pg_connect($conn_str);

for ($i = 0; $i < 10; $i ++) {
pg_query($conn, "INSERT INTO users DEFAULT VALUES");
}

pg_send_query($conn, "SELECT * FROM users");
pg_set_chunked_rows_size($conn, 1);

$result = pg_get_result($conn);
var_dump(pg_num_rows($result));

// No effect after the result is retrieved
var_dump(pg_set_chunked_rows_size($conn, 10));

以上示例会输出：

int(1)
bool(false)

参见