Thread: Counting the rows INSERTed/UPDATEd?
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."
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 ===
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
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
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."