Greetings! I've just found .. nothing! This works pretty well to my
surprise. Thanks so much for the suggestion. I did a little rewrite
which builds a doubly-linked list table of dates, with prior date and
next date columns maintained by triggers. I then retrieve adjacent
pairs of data table rows via a merge with this table. This appears to
be faster than issuing a subselect .... order by ... limit 1 for
each data row, but your key idea (to me, at least) is that I can avoid
sequential sequence numbers by making explicit reference to the order
of the date values themselves.
Thanks again!
Mike Castle <dalgoda@ix.netcom.com> writes:
> On Tue, Dec 05, 2000 at 12:03:40PM -0500, Camm Maguire wrote:
> > need to be able to *quickly* select a pair of *adjacent* rows in a
> > table. t2.seq = t1.seq + 1 seems to work pretty well. Of course, I
>
> What's wrong with a select ... order by .. limit 2 ?
>
> mrc
> --
> Mike Castle Life is like a clock: You can work constantly
> dalgoda@ix.netcom.com and be right all the time, or not work at all
> www.netcom.com/~dalgoda/ and be right at least twice a day. -- mrc
> We are all of us living in the shadow of Manhattan. -- Watchmen
>
>
--
Camm Maguire camm@enhanced.com
==========================================================================
"The earth is but one country, and mankind its citizens." -- Baha'u'llah