Re: best way to fetch next/prev record based on index

Tom Lane <tgl@sss.pgh.pa.us> writes:
> "Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
>> Plus, your where clause does not guarantee results.

> No, but in combination with the ORDER BY it does.

Oh, wait, you're right --- I'm mis-visualizing the situation.

Hmm, it sure seems like there ought to be an easy way to do this...

            regards, tom lane