Search Postgresql Archives

Re: index in desc order

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Szymon Guz <mabewlun@xxxxxxxxx>
Subject: Re: index in desc order
From: AI Rumman <rummandba@xxxxxxxxx>
Date: Tue, 2 Nov 2010 15:57:01 +0600
Cc: pgsql-general General <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <AANLkTikfCFVL47G9xG5y1O3_bbZLTbzxz7MTuBL34HDy@xxxxxxxxxxxxxx>

But I am using Postgresql 8.1. Is it possible here?

On Tue, Nov 2, 2010 at 3:42 PM, Szymon Guz <mabewlun@xxxxxxxxx> wrote:

On 2 November 2010 10:36, AI Rumman <rummandba@xxxxxxxxx> wrote:

Is it possible to create an index in descending order?

yes...

create index i on t(i desc);

regards
Szymon

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: index in desc order
  - From: Sergey Konoplev

References:
- index in desc order
  - From: AI Rumman
- Re: index in desc order
  - From: Szymon Guz

Prev by Date: Re: JDBC Transactions
Next by Date: Re: Dealing with locking on batch updates.
Previous by thread: Re: index in desc order
Next by thread: Re: index in desc order
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux