Re: postgresql stored procedures.
| From: | Ernest E Vogelsinger | Date: | Mon, 26 May 2003 23:13:40 +0000 |
| Subject: | Re: postgresql stored procedures. | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-149016@lists.php.net to get a copy of this message | ||
At 22:29 26.05.2003, Gilberto Garcia Jr. said:
--------------------[snip]--------------------
>Hey guys,
>
>I´m thinking on migrating from mysql to postgresql to be able to use stored
>procedures ang better system performance.
>
>But, I dont know how use php and stored procedures together.
>
>Can someone explain how it works, or point me a manual about that.
>
>Thanks
--------------------[snip]--------------------
The PostgreSQL online manual is full about this - it's not exactly a PHP
related thing.
Basically you call Postgres SP within a SELECT statement, something like
$sql = "select do_something()";
pg_query($conn, $sql);
--
>O Ernest E. Vogelsinger
(\) ICQ #13394035
^ http://www.vogelsinger.at/