Aaron Bono wrote:
On 7/18/06, *Michael Fuhr* <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>> wrote:
<snip>
http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
<snip>
OK, this question got me wondering: is there a way to determine, in a
function/stored procedure, the number of rows that were
inserted/updated/deleted?
<snip>
I could not find any documentation about getting the count of updates
but when you run the update by itself, PostgreSQL reports the number of
records updated so I have to believe the information is available
somewhere.
Thanks,
Aaron
Look for the section entitled "36.6.6. Obtaining the Result Status" on
the link that Michael Fuhr supplied (above). Is that what you are
looking for?
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
