Re: Backwards index scan

Dmitry Tkach <dmitry@openratings.com>

From: Dmitry Tkach <dmitry@openratings.com>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: pgsql-general@postgresql.org
Date: 2003-07-07T21:58:53Z
Lists: pgsql-bugs, pgsql-hackers
>
>
>If you make an opclass that orders in the reverse order you can use that
>opclass in creating the index (which effectively can give you an index
>like x, y desc by using the new opclass on y).  There was some talk
>recently about whether we should provide such opclasses as builtins or
>contrib items.
>  
>
Ah! Nice :-)
I did not think about  it...

Thanks a lot for the hit!

Dima