X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 81C9A9FB1EC for ; Tue, 2 May 2006 06:59:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 96223-04 for ; Tue, 2 May 2006 06:58:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from pjetlic.mobart.hr (pjetlic.mobart.hr [80.80.51.10]) by postgresql.org (Postfix) with ESMTP id 69CB79FA5F6 for ; Tue, 2 May 2006 06:58:47 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by pjetlic.mobart.hr (Postfix) with ESMTP id 0A54817A7C; Tue, 2 May 2006 11:58:45 +0200 (CEST) Received: from pjetlic.mobart.hr ([127.0.0.1]) by localhost (pjetlic [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 30366-02-3; Tue, 2 May 2006 11:58:44 +0200 (CEST) Received: from mike.mobart.hr (mike.mobart.hr [192.168.10.94]) (using SSLv3 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by pjetlic.mobart.hr (Postfix) with ESMTP id E60C21745F; Tue, 2 May 2006 11:58:44 +0200 (CEST) Subject: Re: Counting the rows INSERTed/UPDATEd? From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: Richard Huxton Cc: pgsql-sql@postgresql.org In-Reply-To: <4457149A.6060803@archonet.com> References: <1146499637.8508.1.camel@localhost.localdomain> <4457149A.6060803@archonet.com> Content-Type: text/plain Organization: Mob-Art Date: Tue, 02 May 2006 11:58:43 +0200 Message-Id: <1146563924.5384.0.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by OpenSource AV+AS Mail Server X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/12 X-Sequence-Number: 25043 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."