Re: descending Indexes - Mailing list pgsql-general

From Stephan Szabo
Subject Re: descending Indexes
Date
Msg-id 20030904122945.P44205-100000@megazone.bigpanda.com
Whole thread Raw
In response to descending Indexes  ("Bupp Phillips" <noname@spam.com>)
Responses Re: descending Indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Thu, 4 Sep 2003, Bupp Phillips wrote:

> I can't find a way to create descending Indexes in PG. Is this possible?
>
> If so, can you point me in the right direction?
> If not, can I request this to be an enhancement?

You can do it, but it's a bit difficult.  You need to make an operator
class for the type in question that orders in the reverse order and use
that operator class in making the index.  I don't remember if I sent an
example the last time this came up, but you might want to check the
archives.


pgsql-general by date:

Previous
From: Bjørn T Johansen
Date:
Subject: Backup?
Next
From: Stephan Szabo
Date:
Subject: Re: Replaceing records