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

Поиск
Список
Период
Сортировка
От Gauthier, Dave
Тема Re: how do i get num of recs inserted/deleted/updated in plpgsql
Дата
Msg-id D7FF158337303A419CF4A183F48302D602EA16A9@hdsmsx411.amr.corp.intel.com
обсуждение исходный текст
Ответ на how do i get num of recs inserted/deleted/updated in plpgsql  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Список pgsql-general
Дерево обсуждения

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 по дате отправления:

Предыдущее
От: "Gauthier, Dave"
Дата:
Сообщение: how do i get num of recs inserted/deleted/updated in plpgsql
Следующее
От: "Leif B. Kristensen"
Дата:
Сообщение: Re: how do i get num of recs inserted/deleted/updated in plpgsql