From: Sebastien Baudry <sbaudry@yahoo.com>
To: pgsql-php@postgresql.org
Subject: Re: How to call a PL/pgSQL function in a PHP script
Date: Thu, 2 Oct 2003 10:54:56 +0200
Message-ID: <KAECIKDEBEFAPMGIJGOGOEKDENAA.sbaudry@yahoo.com> (raw)
In-Reply-To: <Pine.BSF.4.21.0310021539490.39488-100000@maiser.unila.ac.id>
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 <sbaudry@yahoo.com>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: sbaudry@yahoo.com
Subject: Re: How to call a PL/pgSQL function in a PHP script
In-Reply-To: <KAECIKDEBEFAPMGIJGOGOEKDENAA.sbaudry@yahoo.com>
References: <Pine.BSF.4.21.0310021539490.39488-100000@maiser.unila.ac.id> <KAECIKDEBEFAPMGIJGOGOEKDENAA.sbaudry@yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox