Jernej Kos <[EMAIL PROTECTED]> writes: > Yes i tried that already - and as you said, it works. But i need to have one > column sorted DESC and one ASC. Is there any way this could be done ?
Not easily. You could look into building a "reverse sort" operator class for one index column or the other. There is discussion of how to do this in the archives, but I don't know of anyone having actually gotten off their duff and done it. For reasonable index performance this would require writing at least one function in C (a pretty trivial one, but nonetheless a C function). regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])