Re: hi let me know the solution to this question

On 7/18/06, Bricklen Anderson <banderson(at)presinet(dot)com> wrote:
>
> Aaron Bono wrote:
> > On 7/18/06, *Michael Fuhr* <mike(at)fuhr(dot)org <mailto:mike(at)fuhr(dot)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
==================================================================