Re: [GENERAL] how do i get num of recs inserted/deleted/updated in plpgsql

2007-08-01 Thread Leif B. Kristensen
On Wednesday 1. August 2007 18:05, Gauthier, Dave wrote: >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. http://www.varlena.com/GeneralBits/23.php 8<- How many rows were aff

Re: [GENERAL] how do i get num of recs inserted/deleted/updated in plpgsql

2007-08-01 Thread Gauthier, Dave
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