From: Aaron Bono <postgresql@aranya.com>
To: Bricklen Anderson <banderson@presinet.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: hi let me know the solution to this question
Date: Tue, 18 Jul 2006 13:35:31 -0500
Message-ID: <bf05e51c0607181135r38fc3446i8370db37bca02bb3@mail.gmail.com> (raw)
In-Reply-To: <44BD1002.6070505@presinet.com>
References: <A70AE049E81A6A40879D5DC0AC8C38C906B08220@venus.infics.com>
<20060718053442.GA9694@winnie.fuhr.org>
<bf05e51c0607180854m48d83301ldc74d4d838c1a42f@mail.gmail.com>
<44BD1002.6070505@presinet.com>
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-DIAGNOSTIC...
> <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
==================================================================
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgresql@aranya.com, banderson@presinet.com
Subject: Re: hi let me know the solution to this question
In-Reply-To: <bf05e51c0607181135r38fc3446i8370db37bca02bb3@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox