Skip site navigation (1) Skip section navigation (2)

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl>
Cc: Christoph Haller <ch(at)rodos(dot)fzk(dot)de>, pgsql-hackers(at)postgresql(dot)org,darko(dot)prenosil(at)finteh(dot)hr
Subject: Re: I cant find it or I'm just lazy ?
Date: 2003-03-06 19:08:34
Message-ID: 200303061908.h26J8Yc19526@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-hackers by date

Next:From: Jeroen T. VermeulenDate: 2003-03-06 19:37:01
Subject: Re: I cant find it or I'm just lazy ?
Previous:From: Merlin MoncureDate: 2003-03-06 19:02:21
Subject: Re: Aggregate "rollup"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group