Thread: Counting the rows INSERTed/UPDATEd?

Counting the rows INSERTed/UPDATEd?

From
Mario Splivalo
Date:
I have found, I thinl, in the pg manual, the way to get the number of
rows inserted/updated, from within the plpgsql. I can't find it anymore,
is that still there, or I misread something earlier?
Mario
-- 
Mario Splivalo
Mob-Art
mario.splivalo@mobart.hr

"I can do it quick, I can do it cheap, I can do it well. Pick any two."




Re: Counting the rows INSERTed/UPDATEd?

From
"A. Kretschmer"
Date:
am  01.05.2006, um 18:07:17 +0200 mailte Mario Splivalo folgendes:
> I have found, I thinl, in the pg manual, the way to get the number of
> rows inserted/updated, from within the plpgsql. I can't find it anymore,

http://www.postgresql.org/docs/8.1/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS

GET DIAGNOSTICS integer_var = ROW_COUNT;


HTH, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net===    Schollglas Unternehmensgruppe    === 


Re: Counting the rows INSERTed/UPDATEd?

From
"Milen A. Radev"
Date:
Mario Splivalo написа:
> I have found, I thinl, in the pg manual, the way to get the number of
> rows inserted/updated, from within the plpgsql. I can't find it anymore,
> is that still there, or I misread something earlier?
> 
>     Mario

May be this one?
http://www.postgresql.org/docs/8.1/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS


-- 
Milen A. Radev



Re: Counting the rows INSERTed/UPDATEd?

From
Richard Huxton
Date:
Mario Splivalo wrote:
> I have found, I thinl, in the pg manual, the way to get the number of
> rows inserted/updated, from within the plpgsql. I can't find it anymore,
> is that still there, or I misread something earlier?

http://www.postgresql.org/docs/8.1/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS

--   Richard Huxton  Archonet Ltd


Re: Counting the rows INSERTed/UPDATEd?

From
Mario Splivalo
Date:
On Tue, 2006-05-02 at 09:13 +0100, Richard Huxton wrote:
> Mario Splivalo wrote:
> > I have found, I thinl, in the pg manual, the way to get the number of
> > rows inserted/updated, from within the plpgsql. I can't find it anymore,
> > is that still there, or I misread something earlier?
> 
> http://www.postgresql.org/docs/8.1/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
> 

Yes, that is it. Thank yall, I guess I was a bit tired and a bit lazy.
Mario
-- 
Mario Splivalo
Mob-Art
mario.splivalo@mobart.hr

"I can do it quick, I can do it cheap, I can do it well. Pick any two."