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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
