View Single Post
Old 22-02-2002, 23:22:54   #58
Darkstar
will bitch for beer
 
Darkstar's Avatar
 
Join Date: Nov 2001
Location: Rocket City
Is it? So, how much trouble would it be to add in a new column that was stamped with (Max_Seq)+1 on insert? It's schema must include the forum & thread, right? Just stamp in the post # for that forum in it, and instant searchability... and that would remain, whether any previous records were deleted...

Humm... currently then it's a Select ID, Sum{} from {table} where {forum} Order by Post_Date and a pop off to that record would get the correct K shot, right? Humm...

If I had the schema, I could get the select worked out... I rarely go seeking a particular index in systems that don't have them in them. Or that we don't add for easy retrieve of interesting records.
__________________
> clue++;
> display clue;
-878923403
Darkstar is offline