PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8
pg_affected_rows - Returns number of affected records (tuples)
Code Examples

pg_affected_rows( PgSql\Result$result ): int

pg_affected_rows returns the number of tuples (instances/records/rows) affected by INSERT, UPDATE, and DELETE queries.

Since PostgreSQL 9.0 and above, the server returns the number of SELECTed rows. Older PostgreSQL return 0 for SELECT.


This function used to be called pg_cmdtuples.



An PgSql\Result instance, returned by pg_query, pg_query_params or pg_execute(among others).

Return Values

The number of rows affected by the query. If no tuple is affected, it will return 0.


Version Description
8.1.0 The result parameter expects an PgSql\Result instance now; previously, a resource was expected.

Related Functions

Example of pg_affected_rows

Show all examples for pg_affected_rows

PHP Version:

Function pg_affected_rows:

PostgreSQL Functions

Most used PHP functions