Re: Hmm, nodeUnique doesn't really support backwards scan too well

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: Hmm, nodeUnique doesn't really support backwards scan too well
Date: 2008-08-05 22:40:08
Message-ID: 20056.1217976008@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Simon Riggs <simon(at)2ndquadrant(dot)com> writes:
> I've never seen anyone scan backwards like this at all in practical use.

> I knew it was possible, but never seen it done.

> It seems entirely probable nobody else has either. It's a PostgreSQL
> extension, so people arriving from outside don't even know it exists,

Say again? Both the SCROLL option to DECLARE CURSOR and FETCH PRIOR are
straight out of the SQL92 spec.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Jaime Casanova 2008-08-05 23:00:10 Re: Hmm, nodeUnique doesn't really support backwards scan too well
Previous Message Simon Riggs 2008-08-05 22:03:32 Re: Hmm, nodeUnique doesn't really support backwards scan too well