pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedCounting the rows INSERTed/UPDATEd?
5+ messages / 4 participants
[nested] [flat]
* Counting the rows INSERTed/UPDATEd?
@ 2006-05-01 16:07 Mario Splivalo <mario.splivalo@mobart.hr>
2006-05-01 18:36 ` Re: Counting the rows INSERTed/UPDATEd? A. Kretschmer <andreas.kretschmer@schollglas.com>
2006-05-01 18:38 ` Re: Counting the rows INSERTed/UPDATEd? Milen A. Radev <milen@radev.net>
2006-05-02 08:13 ` Re: Counting the rows INSERTed/UPDATEd? Richard Huxton <dev@archonet.com>
0 siblings, 3 replies; 5+ messages in thread
From: Mario Splivalo @ 2006-05-01 16:07 UTC (permalink / raw)
To: pgsql-sql
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."
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Counting the rows INSERTed/UPDATEd?
2006-05-01 16:07 Counting the rows INSERTed/UPDATEd? Mario Splivalo <mario.splivalo@mobart.hr>
@ 2006-05-01 18:36 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2 siblings, 0 replies; 5+ messages in thread
From: A. Kretschmer @ 2006-05-01 18:36 UTC (permalink / raw)
To: pgsql-sql
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-DIAGNOSTIC...
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 ===
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Counting the rows INSERTed/UPDATEd?
2006-05-01 16:07 Counting the rows INSERTed/UPDATEd? Mario Splivalo <mario.splivalo@mobart.hr>
@ 2006-05-01 18:38 ` Milen A. Radev <milen@radev.net>
2 siblings, 0 replies; 5+ messages in thread
From: Milen A. Radev @ 2006-05-01 18:38 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Counting the rows INSERTed/UPDATEd?
2006-05-01 16:07 Counting the rows INSERTed/UPDATEd? Mario Splivalo <mario.splivalo@mobart.hr>
@ 2006-05-02 08:13 ` Richard Huxton <dev@archonet.com>
2006-05-02 09:58 ` Re: Counting the rows INSERTed/UPDATEd? Mario Splivalo <mario.splivalo@mobart.hr>
2 siblings, 1 reply; 5+ messages in thread
From: Richard Huxton @ 2006-05-02 08:13 UTC (permalink / raw)
To: mario.splivalo@mobart.hr; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Counting the rows INSERTed/UPDATEd?
2006-05-01 16:07 Counting the rows INSERTed/UPDATEd? Mario Splivalo <mario.splivalo@mobart.hr>
2006-05-02 08:13 ` Re: Counting the rows INSERTed/UPDATEd? Richard Huxton <dev@archonet.com>
@ 2006-05-02 09:58 ` Mario Splivalo <mario.splivalo@mobart.hr>
0 siblings, 0 replies; 5+ messages in thread
From: Mario Splivalo @ 2006-05-02 09:58 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; +Cc: pgsql-sql
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."
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2006-05-02 09:58 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-01 16:07 Counting the rows INSERTed/UPDATEd? Mario Splivalo <mario.splivalo@mobart.hr>
2006-05-01 18:36 ` A. Kretschmer <andreas.kretschmer@schollglas.com>
2006-05-01 18:38 ` Milen A. Radev <milen@radev.net>
2006-05-02 08:13 ` Richard Huxton <dev@archonet.com>
2006-05-02 09:58 ` Mario Splivalo <mario.splivalo@mobart.hr>
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