valgog <[EMAIL PROTECTED]> writes: > how to build an multicolumn index with one column order ASCENDING and > another column order DESCENDING?
Use 8.3 ;-) In existing releases you could fake it with a custom reverse-sorting operator class, but it's a pain in the neck to create one. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate