I found out how to do it: In pl/pgsql: INT nr; UPDATE .... GET DIAGNOSTICS SELECT PROCESSED INTO nr; will put the number of rows into nr. It's a very useful feature to have this in PG7.1. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])