Re: descending Indexes

Yes, I really *need* a descending index.

How do you do a backward scan on an index?

"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote in message
news:17675(dot)1062723498(at)sss(dot)pgh(dot)pa(dot)us(dot)(dot)(dot)
> Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>