Getting actual number of rows updated

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Getting actual number of rows updated
Date: 2005-08-08 07:32:57
Message-ID: 20050808073257.13650.qmail@web52909.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is it possible to have PG report the actual number of
rows that actually CHANGED in an update command? e.g.

UPDATE items set name=replace(name,'abc','def');
UPDATE 9000 -- Actually only 3 were changed

rather than update reporting all rows have been
"updated"?

Thanks,
CSN


____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2005-08-08 07:36:28 Re: tsearch2: very slow queries
Previous Message Christopher Browne 2005-08-08 03:48:33 Re: postgresql Secure Mode