Sugoll the Deformed|
[Most Recent Entries]
Friday, January 2nd, 2009
Suppose I have a table T with columns V and I - V is some value, and I is some increment. Can anyone suggest a query that'll produce the longest sequence of rows where V+I == V', and V'+I' == V'' and so on. The longest continuous sequence of values made up of the different rows, as it were?
I had occasion to restore a file from backup this morning - wasn't really awake when I did the mv-A-tmp-mv-B-A-mv-tmp-B dance - and was thoroughly impressed. Slid nicely back to Christmas eve, clicked on the file I wanted, and clicked on Restore, and watched it float from the past to the present, while the days shifted by beneath it.
I'm tempted to delete a few more files, just to do it again. Current Mood: Impressed. Also, relieved.