Home > mailing lists

Re: Counting the rows INSERTed/UPDATEd? - Mailing list pgsql-sql

From	A. Kretschmer
Subject	Re: Counting the rows INSERTed/UPDATEd?
Date	May 1, 2006 18:36:55
Msg-id	20060501183631.GA22990@webserv.wug-glas.de Whole thread Raw
In response to	Counting the rows INSERTed/UPDATEd? (Mario Splivalo <mario.splivalo@mobart.hr>)
List	pgsql-sql

Tree view

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    ===

pgsql-sql by date:

From: Mario Splivalo
Date: 01 May 2006, 16:07:29
Subject: Counting the rows INSERTed/UPDATEd?

From: "Milen A. Radev"
Date: 01 May 2006, 18:38:56
Subject: Re: Counting the rows INSERTed/UPDATEd?

Re: Counting the rows INSERTed/UPDATEd? - Mailing list pgsql-sql

Previous

Next