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. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])