| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeroen T. Vermeulen | 2003-03-06 19:37:01 | Re: I cant find it or I'm just lazy ? |
| Previous Message | Merlin Moncure | 2003-03-06 19:02:21 | Re: Aggregate "rollup" |