On Jul 23, 7:00 pm, [EMAIL PROTECTED] (Tom Lane) wrote:
> 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
ok, thanks for a rapid answer, can live with the ((-flag),
text_column) functional multicolumn index by now.
Waiting for 8.3 :-)
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
