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

From Jaime Casanova
Subject Re: Hmm, nodeUnique doesn't really support backwards scan too well
Date
Msg-id 3073cc9b0808051600y67ab8eees38a603085bf9ed07@mail.gmail.com
Whole thread Raw
In response to Re: Hmm, nodeUnique doesn't really support backwards scan too well  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Hmm, nodeUnique doesn't really support backwards scan too well
List pgsql-bugs
On 8/5/08, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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.
>

i think Simon is talking about DISTINCT ON

--=20
regards,
Jaime Casanova
Soporte y capacitaci=F3n de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 87171157

pgsql-bugs by date:

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