getting the number of rows affected by a query

[Ow Mun Heng <Ow.Mun.Heng@xxxxxxx>]

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?


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster