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

Re: index: specify sort order?

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: me(at)alternize(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: index: specify sort order?
Date: 2005-08-27 15:52:55
Message-ID: 20050827085043.P73944@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Sat, 27 Aug 2005 me(at)alternize(dot)com wrote:

> in ms-sql it is possible to specify the default order for an index (i.e.
> asc/desc). is this possible in pgsql as well, and if yes, how? i have
> some timestamp indices that i only use to sort the entries in descending
> sortorder...

Well, if it's a single column index and sort we should be able to use the
index backwards to do the sort (Explain would show Index Scan Backwards).
Can you give more information on what precisely you're doing?


In response to

Responses

pgsql-novice by date

Next:From: meDate: 2005-08-27 16:25:29
Subject: Re: index: specify sort order?
Previous:From: meDate: 2005-08-27 15:34:12
Subject: index: specify sort order?

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