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
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
pgsql-novice by date
|Next:||From: me||Date: 2005-08-27 16:25:29|
|Subject: Re: index: specify sort order?|
|Previous:||From: me||Date: 2005-08-27 15:34:12|
|Subject: index: specify sort order?|