valgog <valgog(at)gmail(dot)com> wrote ..
> On Jul 23, 7:00 pm, t(dot)(dot)(dot)(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote:
> > valgog <val(dot)(dot)(dot)(at)gmail(dot)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.
I've often gotten what I want by using a calculated index on (f1, -f2). ORDER BY will take an expression, e.g. ORDER BY f1, -f2. Simpler than a custom operator.
pgsql-performance by date
|Next:||From: valgog||Date: 2007-07-24 07:33:55|
|Subject: Re: disable archiving|
|Previous:||From: Jignesh K. Shah||Date: 2007-07-24 04:09:00|
|Subject: Second SpecJAppserver2004 with PostgreSQL|