mock5c
asked on
Simulate an update query in Postgres
Is there a way I can simulate an update query so it will tell me a certain of number of rows would be updated but doesn't actually update them?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
use transaction control and rollback your changes.
begin work;
update xxx...
rollback work;
begin work;
update xxx...
rollback work;
select count(*) from ... where ...