descending indexes - Mailing list pgsql-novice

From Steve Owen
Subject descending indexes
Date
Msg-id 3E2047A6.7050109@keymarksystems.com
Whole thread Raw
Responses Re: descending indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: "Ville Jungman"
Date:
Subject: Reference to multiple cols
Next
From: Tom Lane
Date:
Subject: Re: descending indexes