Skip site navigation (1) Skip section navigation (2)

Re: multicolumn index column order

From: valgog <valgog(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: multicolumn index column order
Date: 2007-07-23 17:13:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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.
>                         regards, tom lane
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at

ok, thanks for a rapid answer, can live with the ((-flag),
text_column) functional multicolumn index by now.

Waiting for 8.3 :-)

In response to


pgsql-performance by date

Next:From: Paul van den BogaardDate: 2007-07-23 17:24:48
Subject: disable archiving
Previous:From: Tom LaneDate: 2007-07-23 17:00:40
Subject: Re: multicolumn index column order

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group