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 57DAAD1B55C for ; Thu, 2 Oct 2003 08:04:38 +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 38564-02 for ; Thu, 2 Oct 2003 05:03:51 -0300 (ADT) Received: from mail1.dr.myx.net (mail1.dr.myx.net [217.10.193.161]) by svr1.postgresql.org (Postfix) with ESMTP id 3B616D1B553 for ; Thu, 2 Oct 2003 05:03:49 -0300 (ADT) Received: from workstation24 (unknown [81.12.137.146]) by mail1.dr.myx.net (mydomain.myx.net) with ESMTP id B6BF030092F; Thu, 2 Oct 2003 11:03:48 +0300 (EEST) Message-ID: <049001c388bb$d637f840$0600a8c0@fix.ro> From: "Viorel Dragomir" To: , References: Subject: Re: How to call a PL/pgSQL function in a PHP script? Date: Thu, 2 Oct 2003 11:04:42 +0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/2 X-Sequence-Number: 2363 $query = "SELECT myfunc(param1, param2, param3)"; vio- ----- Original Message ----- From: "Sebastien Baudry" To: Sent: Thursday, October 02, 2003 11:00 AM Subject: [PHP] How to call a PL/pgSQL function in a PHP script? > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend