From: valgog <valgog@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: multicolumn index column order
Date: Mon, 23 Jul 2007 17:13:16 -0000
Message-ID: <1185210796.731691.206490@g4g2000hsf.googlegroups.com> (raw)
In-Reply-To: <28463.1185210040@sss.pgh.pa.us>
References: <1185209223.224236.163350@57g2000hsv.googlegroups.com>
<28463.1185210040@sss.pgh.pa.us>
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 :-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: valgog@gmail.com
Subject: Re: multicolumn index column order
In-Reply-To: <1185210796.731691.206490@g4g2000hsf.googlegroups.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox