X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 7CC8DD1D299 for ; Thu, 8 Apr 2004 12:23:27 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 82122-01 for ; Thu, 8 Apr 2004 12:23:23 -0300 (ADT) Received: from vsmtp4.tin.it (unknown [212.216.176.150]) by svr1.postgresql.org (Postfix) with ESMTP id CC712D1BAA5 for ; Thu, 8 Apr 2004 12:23:21 -0300 (ADT) Received: from caronte.webthatworks.it (80.180.154.93) by vsmtp4.tin.it (7.0.027) id 4061B1B600336AD8 for pgsql-php@postgresql.org; Thu, 8 Apr 2004 17:23:17 +0200 Received: from stige.webthatworks.it (stige.webthatworks.it [192.168.1.5]) by caronte.webthatworks.it (Postfix) with ESMTP id D24282300C4 for ; Thu, 8 Apr 2004 17:23:11 +0200 (CEST) Received: from stige.webthatworks.it (localhost [127.0.0.1]) by stige.webthatworks.it (Postfix) with SMTP id 6A106294068 for ; Thu, 8 Apr 2004 17:23:41 +0200 (CEST) Date: Thu, 8 Apr 2004 17:23:41 +0200 From: Ivan Sergio Borgonovo To: pgsql-php@postgresql.org Subject: functions aka stored procedures results and PHP Message-Id: <20040408172341.52742d2b@stige.webthatworks.it> Organization: WebThatWorks.it X-Mailer: Sylpheed version 0.9.10claws (GTK+ 1.2.10; i686-suse-linux) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/16 X-Sequence-Number: 2673 Is there a tutorial on how to get back results from PL/pgSQL functions in PHP? I've several doubt about memory usage, getting back cursors or recordsets or single rows or just a value. What will happen if I have several SELECT in the same PL/pgSQL function? Will they give back several recordset and how? thx