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

Re: multicolumn index column order

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: valgog <valgog(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: multicolumn index column order
Date: 2007-07-23 17:00:40
Message-ID: 28463.1185210040@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
valgog <valgog(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

In response to

Responses

pgsql-performance by date

Next:From: valgogDate: 2007-07-23 17:13:16
Subject: Re: multicolumn index column order
Previous:From: valgogDate: 2007-07-23 16:47:03
Subject: multicolumn index column order

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