Perhaps....
rowcnt integer;
...
get diagnostics rowcnt := row_count;
???
________________________________
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Gauthier, Dave
Sent: Wednesday, August 01, 2007 12:05 PM
To: pgsql-general(at)postgresql(dot)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