Re: descending Indexes - Mailing list pgsql-general

From Relaxin
Subject Re: descending Indexes
Date
Msg-id bj8oiu$17lj$1@news.hub.org
Whole thread Raw
In response to Re: descending Indexes  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Responses Re: descending Indexes  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Yes, I really *need* a descending index.

How do you do a backward scan on an index?

"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:17675.1062723498@sss.pgh.pa.us...
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>



pgsql-general by date:

Previous
From: Henrique Lima
Date:
Subject: Inquiry From Form [pgsql]
Next
From: Christopher Browne
Date:
Subject: Re: descending Indexes