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 80AEB9FA1B0 for ; Tue, 2 May 2006 05:13:44 -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 48365-09 for ; Tue, 2 May 2006 05:13:34 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from pih-relay04.plus.net (pih-relay04.plus.net [212.159.14.131]) by postgresql.org (Postfix) with ESMTP id 99EE29FA255 for ; Tue, 2 May 2006 05:13:30 -0300 (ADT) Received: from [213.162.97.75] (helo=mail.metronet.co.uk) by pih-relay04.plus.net with esmtp (Exim) id 1Faq0Z-0005dY-MV; Tue, 02 May 2006 09:13:23 +0100 Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id 13A0F748A6; Tue, 2 May 2006 09:17:45 +0100 (BST) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 3709F15EA6; Tue, 2 May 2006 09:13:15 +0100 (BST) Message-ID: <4457149A.6060803@archonet.com> Date: Tue, 02 May 2006 09:13:14 +0100 From: Richard Huxton User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: mario.splivalo@mobart.hr Cc: pgsql-sql@postgresql.org Subject: Re: Counting the rows INSERTed/UPDATEd? References: <1146499637.8508.1.camel@localhost.localdomain> In-Reply-To: <1146499637.8508.1.camel@localhost.localdomain> Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/11 X-Sequence-Number: 25042 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