Postgres Pro
Downloads
Home   >   mailing lists

Re: Hmm, nodeUnique doesn't really support backwards scan too well - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Hmm, nodeUnique doesn't really support backwards scan too well
Date
Msg-id 20056.1217976008@sss.pgh.pa.us
Whole thread Raw
In response to Re: Hmm, nodeUnique doesn't really support backwards scan too well  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Hmm, nodeUnique doesn't really support backwards scan too well
List pgsql-bugs
Tree view 
Simon Riggs <simon@2ndquadrant.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

pgsql-bugs by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Hmm, nodeUnique doesn't really support backwards scan too well
Next
From: "Jaime Casanova"
Date:
Subject: Re: Hmm, nodeUnique doesn't really support backwards scan too well