Re: descending Indexes

On Thu, Sep 04, 2003 at 18:24:01 -0700,
Relaxin <noname(at)spam(dot)com> wrote:
> Yes, I really *need* a descending index.

Can you go into more detail about this?

Generally you only need a descending index if it has more than one part
and one part needs to be ascending and the other needs to be descending.
If this case then general solution is to create a new operator class.
In 7.4, you will be able to get around this is some cases by using a
functional index on - whatever and using - whatever in the query. (This
will only work on datatypes that have a unary - defined, so is pretty much
limited to numeric types.)