Postgres Pro
Downloads
Home   >   mailing lists

Re: index in desc order - Mailing list pgsql-general

From AI Rumman
Subject Re: index in desc order
Date
Msg-id AANLkTimOSoHmBwn0MGjdT8vvt4qpJ2koxGW_X3-O9kev@mail.gmail.com
Whole thread Raw
In response to Re: index in desc order  (Szymon Guz <mabewlun@gmail.com>)
Responses Re: index in desc order  (Sergey Konoplev <gray.ru@gmail.com>)
List pgsql-general
Tree view
But I am using Postgresql 8.1. Is it possible here?

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


On 2 November 2010 10:36, AI Rumman <rummandba@gmail.com> wrote:
Is it possible to create an index in descending order?

yes...

create index i on t(i desc);


regards
Szymon

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: JDBC Transactions
Next
From: Szymon Guz
Date:
Subject: Re: Dealing with locking on batch updates.