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

["Gauthier, Dave" <dave.gauthier@xxxxxxxxx>]

Perhaps....

 

rowcnt integer;

...

get diagnostics rowcnt := row_count;

 

???

 

---

From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Gauthier, Dave
Sent: Wednesday, August 01, 2007 12:05 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: 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