Re: update count

On Dec 18, 2005, at 3:50 AM, Chris Velevitch wrote:

> (for v7.4.5) How do I get the number of rows updated by an update
> command?

In general, the UPDATE command tells you the number of updated rows:

Outputs

On successful completion, an UPDATE command returns a command tag of
the form

UPDATE count
The count is the number of rows updated. If count is 0, no rows
matched the condition (this is not considered an error).

http://www.postgresql.org/docs/8.1/interactive/sql-update.html

The actual details of getting this number depends on what client API
you are using to execute the UPDATE command.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL