Re: Using Cursors in PHP - Mailing list pgsql-php

On 8 Aug 2003, Markus Bertheau wrote:

> В Срд, 06.08.2003, в 17:51, scott.marlowe пишет:
> > On Wed, 6 Aug 2003, Andreas Schmitz wrote:
> >
> > >
> > > Hello *,
> > >
> > > I am just wondering if it is possible to use cursors within PHP. I need to
> > > page query result from a big table and I am looking for a solution to avoid
> > > scanning the complete table using limit and offset.
> >
> > Yes, you can use cursors, no you can't expect them to survive from one
> > page to the next.
>
> What about the new feature in cursors "WITH HOLD"? Don't they survive?

I don't think so.  Basically, PHP is supposed to reset the connection if
it's persistant, and if it isn't persistant, then it's always a new
connection, which means a cursor shouldn't survive.

But I'm NOT familiar with "WITH HOLD" right now, so someone else who knows
that better may have a more definitive answer.