Re: Scroll cursor oddity... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Scroll cursor oddity...
Date
Msg-id 2178.1207061561@sss.pgh.pa.us
Whole thread Raw
In response to Scroll cursor oddity...  (Mike Aubury <mike.aubury@aubit.com>)
Responses Re: Scroll cursor oddity...  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-hackers
Mike Aubury <mike.aubury@aubit.com> writes:
> ie - under postgresql it appears we've scrolled *past* the last row and need 
> an additional fetch to get back to our last row..

Why do you find that surprising?  It seems to me to be symmetrical with
the case at the beginning of the table --- the cursor is initially
positioned before the first row.  Why shouldn't there be a corresponding
state where it's positioned after the last row?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: build multiple indexes in single table pass?
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] ANALYZE getting dead tuple count hopelessly wrong