| From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
|---|---|
| To: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: how do i get num of recs inserted/deleted/updated in plpgsql |
| Date: | 2007-08-01 16:14:01 |
| Message-ID: | D7FF158337303A419CF4A183F48302D602EA16A9@hdsmsx411.amr.corp.intel.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Leif B. Kristensen | 2007-08-01 16:20:43 | Re: how do i get num of recs inserted/deleted/updated in plpgsql |
| Previous Message | Gauthier, Dave | 2007-08-01 16:05:29 | how do i get num of recs inserted/deleted/updated in plpgsql |