On 7/18/06,
Bricklen Anderson <
banderson@presinet.com> wrote:
Aaron Bono wrote:
> On 7/18/06, *Michael Fuhr* <mike@fuhr.org <mailto:mike@fuhr.org>> 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?
Ah yes, I missed the part on
ROW_COUNT . That should do it.
==================================================================
Aaron Bono
Aranya Software Technologies, Inc.
http://www.aranya.com==================================================================
