PostgreSQL module does not have cursor.
All you have to do is execute query then
fetch records one by one. For example,
$result = pg_query($db_connection, 'select * from your_table;');
while ($record = pg_fetch_array($result)) {
print_r($record);
}
Above code can be used to print all records in
a result set.
--
Yasuo Ohgaki
Brown wrote:
> # 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
