Search Postgresql Archives

Re: Cursors and PHP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Tom Lane wrote:

Steve Manes <smanes@magpie.com> writes:

$query = "SELECT get_user_data('$cursor', $user_id);FETCH ALL IN $cursor;";


$res =& $dbh->query($query);


Hm.  This will return two different, not-compatible result sets (the
SELECT's output and then the FETCH's).

Without the FETCH in that compound PHP query however, nothing gets returned from the SELECT. I'm not sure why but maybe it's because PEAR::DB doesn't have any direct support for cursors so it's just grabbing a result set.





---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux