From: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
---|---|
To: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, bruc(at)stone(dot)congenomics(dot)com |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | AW: Various silliness in heap_getnext and related routi nes |
Date: | 2001-06-11 07:35:14 |
Message-ID: | 11C1E6749A55D411A9670001FA68796336831A@sdexcsrv1.f000.d0188.sd.spardat.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> These pointers are useless
> except in the very unusual case where one steps forward and then back
> in a sequential scan (for example, "FETCH 1; FETCH BACKWARD 1;" in a
> cursor).
Actually I think it should be known whether a fetch backward is actually
allowed for a particular cursor, since it usually needs to be declared
as a scroll cursor explicitly.
> It seems to me that this is wrongheaded. We could simplify
> and speed up the normal case by maintaining only a "current" pointer,
> which would be well worth the extra work in the forward/back
> step case.
So it probably does pay off for a cursor, that is explicitly requested
to be scrollable, but certainly not for others, yes.
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Deblier | 2001-06-11 08:19:52 | dlopen() of libpgsqlodbc.so >= release 7.1 fails on sparc solaris 2.8 |
Previous Message | Zeugswetter Andreas SB | 2001-06-11 07:05:07 | AW: Re: AW: Re: [SQL] behavior of ' = NULL' vs. MySQL v s. Stand ards |