Postgres Pro
Downloads
Home   >   mailing lists

Finding the number of rows affected by UPDATE or INSERT? - Mailing list pgsql-general

From Dr. Evil
Subject Finding the number of rows affected by UPDATE or INSERT?
Date
Msg-id 20010830055722.26740.qmail@sidereal.kz
Whole thread Raw
Responses Solution found! was Re: Finding the number of rows affected by UPDATE or INSERT?  ("Dr. Evil" <drevil@sidereal.kz>)
List pgsql-general
Tree view 
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 by date:

Previous
From: A_Schnabel@t-online.de (Andre Schnabel)
Date:
Subject: Re: Compaq iPAQ and Postgresql
Next
From: "Joe Conway"
Date:
Subject: Re: Finding the number of rows affected by UPDATE or INSERT?