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.