Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2FGZYx28227 for ; Thu, 15 Mar 2001 11:35:34 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f2FGZSt14116; Thu, 15 Mar 2001 11:35:28 -0500 (EST) To: josh@agliodbs.com cc: sqllist Subject: Re: Some questions about PLpgSql In-reply-to: <3AB0EC96.236515D4@agliodbs.com> References: <002801c0ad3f$a2c77760$2400a8c0@hnjack> <3AB0EC96.236515D4@agliodbs.com> Comments: In-reply-to Josh Berkus message dated "Thu, 15 Mar 2001 08:23:50 -0800" Date: Thu, 15 Mar 2001 11:35:28 -0500 Message-ID: <14113.984674128@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200103/313 X-Sequence-Number: 1977 Josh Berkus writes: > Now, testing how many rows were inserted/updated/deleted ... that I'm > not sure about. It would be nice to have a ROWS_AFFECTED returned from > a data manipulation query in PL/pgSQL, but I don't believe that that has > been implemented. It has as of 7.1 --- see GET DIAGNOSTICS foo = ROW_COUNT. regards, tom lane