I'm trying to do some periodic updates from another DB and would like to
know the # of updates/inserts/deletes from that job.
I usually write a function which gets/uses the GETS DIAGNOSTIC ROW COUNT
parameter which will tell me how many rows were affected by the query.
Now, for this case, I'm not writing a function but merely using a normal
SQL eg:
BEGIN;
DELETE FROM foo where (x) = (select x from foobar);
INSERT INTO foo select * from foobar;
-- then I would like to update a log_table
-- eg: insert into log(proc,tablname,ins_row,delete_rows)
-- values ('update','foo',XXX,YYY)
COMMIT;
Is there a way to do this?
