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

From Tom Lane
Subject Re: multicolumn index column order
Date
Msg-id 28463.1185210040@sss.pgh.pa.us
Whole thread Raw
In response to multicolumn index column order  (valgog <valgog@gmail.com>)
Responses Re: multicolumn index column order  (valgog <valgog@gmail.com>)
List pgsql-performance
valgog <valgog@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

pgsql-performance by date:

Previous
From: valgog
Date:
Subject: multicolumn index column order
Next
From: valgog
Date:
Subject: Re: multicolumn index column order