From: Alvaro Herrera <alvherre@commandprompt.com>
To: Theo Kramer <theo@flame.co.za>
Cc: pgsql-performance@postgresql.org
Subject: Re: Indexes with descending date columns
Date: Thu, 23 Mar 2006 09:24:49 -0400
Message-ID: <20060323132448.GB4881@surnet.cl> (raw)
In-Reply-To: <1143112188.2810.27.camel@theo-laptop.int.coza.net.za>
References: <200603170625.k2H6PJ926955@pillette.com>
<1143112188.2810.27.camel@theo-laptop.int.coza.net.za>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@commandprompt.com, theo@flame.co.za
Subject: Re: Indexes with descending date columns
In-Reply-To: <20060323132448.GB4881@surnet.cl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox