pgSQL Stored Procedures
| From: | David Busby | Date: | Thu, 11 Jul 2002 21:30:00 +0000 |
| Subject: | pgSQL Stored Procedures | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-107229@lists.php.net to get a copy of this message | ||
List,
Has anyone built Functions (or Stored Procedures) in PostgreSQL that can return a dataset? I would like to contain my login in PostgreSQL (like I did on M$-SQL) and call it from my PHP script (like I did with ASP).
Ex:
$rs = pg_exec($db, "someprocname")
while ($rec = pg_result_object($rs, $row)) {
// Stuff
}
Now "someprocname" should be on my PostgreSQL server and containts a SELECT statement whos results I want to send back to PHP for the $rs var. Has anyone got this working? I've tried all kinds of good stuff but can't get it to happen...
TIA
/B