On Fri, 23 Jan 2004, Jenny Zhang wrote:
> 3. index with desc/asc is not supported in PG, why it is not needed? Is
> there any work-around?
You can do this with index operator classes. There aren't any
automatically provided ones that do the reversed sort iirc, but I think
that's come up before with examples. I've toyed with the idea of writing
the reverse opclasses for at least some of the types, but haven't been
seriously motivated to actually get it done.
In response to
pgsql-performance by date
|Next:||From: Randolf Richardson||Date: 2004-01-26 06:35:34|
|Subject: Re: Persistent Connections|
|Previous:||From: Ivan Voras||Date: 2004-01-25 12:23:23|
|Subject: Re: Benchmarking PostgreSQL?|