X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3FA825632F; Thu, 24 Feb 2005 22:32:39 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95653-01; Thu, 24 Feb 2005 22:32:36 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4010256302; Thu, 24 Feb 2005 22:32:35 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j1OMWmA5028072; Thu, 24 Feb 2005 17:32:48 -0500 (EST) To: "Francisco Figueiredo Jr." Cc: pgsql-hackers@postgresql.org, pgsql-jdbc@postgresql.org Subject: Re: [JDBC] Where are we on stored procedures? In-reply-to: <20050224214935.57272.qmail@web60703.mail.yahoo.com> References: <20050224214935.57272.qmail@web60703.mail.yahoo.com> Comments: In-reply-to "Francisco Figueiredo Jr." message dated "Thu, 24 Feb 2005 18:49:35 -0300" Date: Thu, 24 Feb 2005 17:32:48 -0500 Message-ID: <28071.1109284368@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.008 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/797 X-Sequence-Number: 64625 "Francisco Figueiredo Jr." writes: > Could I add another item? > Could we have the row count of statements executed inside a > procedure/function returned to client? IMHO that request is completely bogus; if the procedure wants to tell the client that, it's the procedure's responsibility to return the number as a result. Doing what you ask (a) would arguably be a security violation, and (b) the info would be impossible for the client to interpret in any but the most trivial cases anyway. Consider for instance a procedure that contains different queries in the THEN and the ELSE arms of an IF, or contains loops executed a variable number of times. Without access to the results of the control flow tests, the client could not know which number means what. regards, tom lane