Postgres Pro
Downloads
Home   >   mailing lists

Re: how do i get num of recs inserted/deleted/updated in plpgsql - Mailing list pgsql-general

From Gauthier, Dave
Subject Re: how do i get num of recs inserted/deleted/updated in plpgsql
Date
Msg-id D7FF158337303A419CF4A183F48302D602EA16A9@hdsmsx411.amr.corp.intel.com
Whole thread Raw
In response to how do i get num of recs inserted/deleted/updated in plpgsql  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
Tree view

Perhaps....

 

rowcnt integer;

...

get diagnostics rowcnt := row_count;

 

???

 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] 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

 

 

 

 

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: how do i get num of recs inserted/deleted/updated in plpgsql
Next
From: "Leif B. Kristensen"
Date:
Subject: Re: how do i get num of recs inserted/deleted/updated in plpgsql