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

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