Re: Indexes with descending date columns

[Alvaro Herrera <alvherre(at)commandprompt(dot)com>]

Theo Kramer wrote:

> All good input - thanks, however, before I start messing with my stuff
> which I know will be complex - some questions to any of the developers
> on the list.
> 
> i  Is it feasible to extend index creation to support descending 
>    columns? ... this is supported on other commercial and non
>    commercial databases, but I do not know if this is a SQL standard.

This can be done.  You need to create an operator class which specifies
the reverse sort order (i.e. reverse the operators), and then use it in
the new index.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.