On Mar 29, 2005, at 3:48 PM, Cima wrote:
>
> how do i call a stored procedure i have in postgresql 8.0.1 from php
> with the necesary parameters or variables?
You don't say want php interface you are using, but with the standard
pgsql interface included with php it might look something like this:
$x = 3;
$result = pg_query($conn, "select myprocedure(1, 2, $x);");
$rows = pg_fetch_all($result);
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL