On 2 November 2010 12:57, AI Rumman <[email protected]> wrote: > But I am using Postgresql 8.1. Is it possible here?
I am afraid not. You could try to do the index using kind of 1/field trick but I am not sure if it performs better than backward index scan in general. > > On Tue, Nov 2, 2010 at 3:42 PM, Szymon Guz <[email protected]> wrote: >> >> >> On 2 November 2010 10:36, AI Rumman <[email protected]> wrote: >>> >>> Is it possible to create an index in descending order? >> >> yes... >> create index i on t(i desc); >> >> regards >> Szymon > -- Sergey Konoplev Blog: http://gray-hemp.blogspot.com / Linkedin: http://ru.linkedin.com/in/grayhemp / JID/GTalk: [email protected] / Skype: gray-hemp -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
