Re: Scroll cursor oddity...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mike Aubury <mike(dot)aubury(at)aubit(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Scroll cursor oddity...
Date: 2008-04-01 14:52:41
Message-ID: 2178.1207061561@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Mike Aubury <mike(dot)aubury(at)aubit(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-04-01 15:00:15 Re: [HACKERS] ANALYZE getting dead tuple count hopelessly wrong
Previous Message Tom Lane 2008-04-01 14:50:32 Re: build multiple indexes in single table pass?