Re: Using Cursors in PHP

From: Markus Bertheau <twanger(at)bluetwanger(dot)de>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: Andreas Schmitz <a(dot)schmitz(at)cityweb(dot)de>, pgsql-php(at)postgresql(dot)org
Subject: Re: Using Cursors in PHP
Date: 2003-08-08 08:01:40
Message-ID: 1060329700.4453.0.camel@severn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

В Срд, 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?

--
Markus Bertheau <twanger(at)bluetwanger(dot)de>

In response to

Responses

Browse pgsql-php by date

  From Date Subject
Next Message scott.marlowe 2003-08-08 13:22:18 Re: Using Cursors in PHP
Previous Message Marc G. Fournier 2003-08-07 17:49:43 Testing gateway