Re: multicolumn index column order - Mailing list pgsql-performance

From valgog
Subject Re: multicolumn index column order
Date
Msg-id 1185210796.731691.206490@g4g2000hsf.googlegroups.com
Whole thread Raw
In response to Re: multicolumn index column order  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses disable archiving  (Paul van den Bogaard <Paul.Vandenbogaard@Sun.COM>)
List pgsql-performance
On Jul 23, 7:00 pm, t...@sss.pgh.pa.us (Tom Lane) wrote:
> valgog <val...@gmail.com> 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 :-)


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: multicolumn index column order
Next
From: Paul van den Bogaard
Date:
Subject: disable archiving