Re: I cant find it or I'm just lazy ?

Jeroen T. Vermeulen wrote:
> On Tue, Feb 25, 2003 at 02:04:50PM +0100, Christoph Haller wrote:
> >
> > Anyway, you may MOVE until 0 instead of FETCH, or use the COUNT()
> > function on the query to learn about the number of rows to be returned.
> 
> Hmm...  Wouldn't the reliability of a count() depend on the isolation
> level?
> 
> OTOH the problem with MOVE ALL is that not all cursors support backward
> scrolling, apparently, and there is no clear documentation (or even
> diagnostics!) to determine whether they do.

7.4 does document MOVE ALL as going to the end of the cursor.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073