X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 41CF2D1B53F for ; Thu, 2 Oct 2003 07:59:01 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 35670-06 for ; Thu, 2 Oct 2003 04:58:16 -0300 (ADT) Received: from smtp014.mail.yahoo.com (smtp014.mail.yahoo.com [216.136.173.58]) by svr1.postgresql.org (Postfix) with SMTP id E5838D1B500 for ; Thu, 2 Oct 2003 04:58:13 -0300 (ADT) Received: from adsl24.226.axelero.hu (HELO loser2000) (sbaudry@195.228.226.24 with login) by smtp.mail.vip.sc5.yahoo.com with SMTP; 2 Oct 2003 07:58:14 -0000 Reply-To: From: "Sebastien Baudry" To: Subject: How to call a PL/pgSQL function in a PHP script? Date: Thu, 2 Oct 2003 10:00:10 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=MSGID_GOOD_EXCHANGE, RCVD_IN_OSIRUSOFT_COM X-Spam-Level: X-Archive-Number: 200310/1 X-Sequence-Number: 2362 Hi, I created functions (using PL/pgSQL) in my PostGreSQL database and now I try to call them in my PHP script but it doesn't succeed. I can open a connection to the database, run a simple query and get the result, but I don't know how to do with the functions. Anybody could help me? -- Sébastien BAUDRY - DBA Oracle/MS-SQL & Project Manager BAUDRY ENGINEERING BT. H-1025 Budapest Verhalom utca. 31/D. I/8. @.: sebastien.baudry@baudry-engineering.com mobile.: +36-30-392-0279 / tel: +36-1-326-0241 / fax: +36-1-326-0241 http://www.baudry-engineering.com