[PHP-DB] [Q] EXT SQL IN PostgreSQL From: brown (brown <email protected>)
Date: 06/21/02

# Sorry to my poor English

I have a procedure ( named by select_table )

##########################################
BEGIN;
select select_table('select_cur','table_name');
FETCH ALL IN select_cur;
COMMIT;
##########################################

This Query is right In Console (psql).

I wanna see a result with php.

$sql = "
BEGIN;
select select_table('select_cur','table_name');
FETCH ALL IN select_cur;
COMMIT;
";
$result = pg_exec($connect,$sql);
$row = pg_fetch_row($result);

is not run.

How can I get the CURSOR from PostgreSQL with PHP ? 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php