On Sun, Dec 08, 2002 at 05:28:22PM -0500, Tom Lane wrote:
>
> Well, you could dig through backend/executor/node*.c and see which of
> the node types pay attention to es_direction. To a first approximation
> it looks like these do:
I'll be honest with you: I don't know much about the internals a
"Jeroen T. Vermeulen" <[EMAIL PROTECTED]> writes:
> Now if I understood a bit more of what's going on here, at least I could
> document it...
Well, you could dig through backend/executor/node*.c and see which of
the node types pay attention to es_direction. To a first approximation
it looks like
On Sun, Dec 08, 2002 at 05:09:09PM -0500, Tom Lane wrote:
>
> > Is any of this described in the docs somewhere?
>
> Fraid not.
Damn & blast. I was rather counting on cursors that could back up for
my nifty CachedResult class (which acts more or less like a normal result
set but transparently f
"Jeroen T. Vermeulen" <[EMAIL PROTECTED]> writes:
> Ah, I didn't know that. I guess the plan for "select * from pg_tables"
> must have changed in 7.3 then.
[looks...] Yeah, there's a join to pg_namespace in there now.
> Is any of this described in the docs somewhere?
Fraid not.
On Sun, Dec 08, 2002 at 04:28:38PM -0500, Tom Lane wrote:
>
> I believe it is true though that backing up a cursor only works for
> certain plan types (seqscan, indexscan, sort, maybe a couple others).
> That has always been true --- 7.3 is no better nor worse than prior
> releases.
Ah, I didn't
"Jeroen T. Vermeulen" <[EMAIL PROTECTED]> writes:
> Looking at my problem with changed cursor behaviour in 7.3 again, I
> noticed something interesting: a cursor in 7.3 apparently does not let
> you scroll back to its first row at all!
Oh?
regression=# begin;
BEGIN
regression=# declare c cursor
Looking at my problem with changed cursor behaviour in 7.3 again, I
noticed something interesting: a cursor in 7.3 apparently does not let
you scroll back to its first row at all! Neither a "move backward all"
or a "move -n" where n is equal to or greater than the cursor's current
position, will