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 C7868D1B4F1 for ; Thu, 2 Oct 2003 08:53:46 +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 45433-10 for ; Thu, 2 Oct 2003 05:53:02 -0300 (ADT) Received: from smtp017.mail.yahoo.com (smtp017.mail.yahoo.com [216.136.174.114]) by svr1.postgresql.org (Postfix) with SMTP id A3988D1B547 for ; Thu, 2 Oct 2003 05:52:59 -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 08:52:59 -0000 Reply-To: From: "Sebastien Baudry" To: Subject: Re: How to call a PL/pgSQL function in a PHP script Date: Thu, 2 Oct 2003 10:54:56 +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 In-Reply-To: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/4 X-Sequence-Number: 2365 Sorry, I should have precised that my PL/pgSQL function returns a REFCURSOR and it's that cursor that I don't know how to manipulate in my PHP script. -----Message d'origine----- De : pgsql-php-owner@postgresql.org [mailto:pgsql-php-owner@postgresql.org]De la part de Ahmad Sentri Envoyé : Thursday, October 02, 2003 10:46 AM À : sebastien.baudry@baudry-engineering.com Cc : pgsql-php@postgresql.org Objet : Re: [PHP] How to call a PL/pgSQL function in a PHP script in php syntax for call a function u can use in sql select a function that already made the way u can write in php syntax with : $sql_select="SELECT name_of_fanction(var1,var2,...) from name_of_table === so if u make a function with the name: name_function so : $sql_select="SELECT name_function(var1) from table On Thu, 2 Oct 2003, Sebastien Baudry wrote: > Date: Thu, 2 Oct 2003 10:00:10 +0200 > From: Sebastien Baudry > Reply-To: sebastien.baudry@baudry-engineering.com > To: pgsql-php@postgresql.org > 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 > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly