Finding the number of rows affected by UPDATE or INSERT?

Поиск
Список
Период
Сортировка
От Dr. Evil
Тема Finding the number of rows affected by UPDATE or INSERT?
Дата
Msg-id 20010830055722.26740.qmail@sidereal.kz
обсуждение исходный текст
Ответы Solution found! was Re: Finding the number of rows affected by UPDATE or INSERT?  ("Dr. Evil" <drevil@sidereal.kz>)
Список pgsql-general
I am writing a bunch of stuff in pl/pgsql, and some of these functions
do UPDATEs or INSERTs on various tables.  How could I find out, from
within the pl/pgsql function, how many rows were affected?  This way,
if the update or insert fails for some reason, I can return a "failed"
message from the function, instead of pretending that everything is
ok.

Thanks

В списке pgsql-general по дате отправления:

Предыдущее
От: A_Schnabel@t-online.de (Andre Schnabel)
Дата:
Сообщение: Re: Compaq iPAQ and Postgresql
Следующее
От: "Joe Conway"
Дата:
Сообщение: Re: Finding the number of rows affected by UPDATE or INSERT?