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

Re: Enhancement suggestion

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dann Corbit" <DCorbit(at)connx(dot)com>
Cc: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Enhancement suggestion
Date: 2005-02-02 17:36:36
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
"Dann Corbit" <DCorbit(at)connx(dot)com> writes:
> Allow ASC/DESC direction modifiers for index columns.

We aren't going to do that, because it would be a meaningless concept
for indexes that don't impose a linear sort order (which is to say,
everything except btrees).  The concept that actually fits into PG's
index structure is to offer reverse-sort-order btree operator classes.
Providing these as standard equipment for all the built-in datatypes
has been discussed several times --- I'm not sure if it's mentioned in
the TODO file but probably it should be.  In the meantime you can cons
up your own reverse order opclass with little effort beyond writing
the one comparison function wrapper.  See the archives for details.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-02-02 17:38:04
Subject: Re: [BUGS] Bug in create operator and/or initdb
Previous:From: Bruce MomjianDate: 2005-02-02 17:26:32
Subject: Re: [NOVICE] Last ID Problem

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