Am Montag, den 08.08.2005, 00:32 -0700 schrieb CSN:
> 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 a
PROTECTED] Behalf Of CSN
Sent: lundi 8 août 2005 09:33
To: pgsql-general@postgresql.org
Subject: [GENERAL] Getting actual number of rows updated
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,'a
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
_
