Perhaps....
rowcnt integer; ... get diagnostics rowcnt := row_count; ??? ________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gauthier, Dave Sent: Wednesday, August 01, 2007 12:05 PM To: pgsql-general@postgresql.org Subject: [GENERAL] how do i get num of recs inserted/deleted/updated in plpgsql Looking to capture the total number of records affected with insert/delete/update from within a plpgsql (v7.4 on linux). Would be nice to have this in an integer. Thanks -dave
