Re: descending Indexes - Mailing list pgsql-general

From Tom Lane
Subject Re: descending Indexes
Date
Msg-id 17675.1062723498@sss.pgh.pa.us
Whole thread Raw
In response to Re: descending Indexes  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-general
Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> On Thu, 4 Sep 2003, Bupp Phillips wrote:
>> I can't find a way to create descending Indexes in PG. Is this possible?

> You can do it, but it's a bit difficult.

Do you really *need* a descending index?  In most cases a backwards scan
on a regular index gets the job done.

            regards, tom lane

pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: searching archives should be a weeeee bit faster ...
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] tablelevel and rowlevel locks