descending indexes

Поиск
Список
Период
Сортировка
От Steve Owen
Тема descending indexes
Дата
Msg-id 3E2047A6.7050109@keymarksystems.com
обсуждение исходный текст
Ответы Re: descending indexes
Список pgsql-novice
I am attempting to port an application that makes extensive use of being
able to scroll forwards or backwards through a large database from a
given, user-defined point  where the key is a CHAR(15) user-defined
field, arbitrarily & frequently inserted & deleted.  Creating an index
on the field speeds up the scroll forwards, but I'm having to jump
through hoops to scroll backwards.  I have searched and cannot find any
reference to a simple method to find the previous key using the index.
Any suggestions?

steve



В списке pgsql-novice по дате отправления:

Предыдущее
От: "Ville Jungman"
Дата:
Сообщение: Reference to multiple cols
Следующее
От: Tom Lane
Дата:
Сообщение: Re: descending indexes