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