(PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8)
pg_free_result — Free result memory
pg_free_result() frees the memory and data associated with the specified PgSql\Result instance.
This function need only be called if memory consumption during script execution is a problem. Otherwise, all result memory will be automatically freed when the script ends.
Note :
This function used to be called pg_freeresult() .
result
An PgSql\Result instance, returned by pg_query() , pg_query_params() or pg_execute() (among others).
| Versionen | Description |
|---|---|
| 8.1.0 |
The
result
parameter expects an
PgSql\Result
instance now; previously, a
ressource
was expected.
|
Example #1 pg_free_result() example
<?php
$db
=
pg_connect
(
"dbname=users user=me"
);
$res
=
pg_query
(
$db
,
"SELECT 1 UNION ALL SELECT 2"
);
$val
=
pg_fetch_result
(
$res
,
1
,
0
);
echo
"First field in the second row is: "
,
$val
,
"\n"
;
pg_free_result
(
$res
);
?>
The above example will output:
First field in the second row is: 2
You do NOT need to call pg_free_result() on every result ressource you create.
When result ressources go out of scope, they are garbague collected just lique everything else.
Unless you're hoarding your resuls somewhere, you can basically ignore this function.
Here's a little test you can run to confirm this:http://pastebin.com/ghw1PHuE