> A guy on this end had a suggestion that I kicked myself for not > thinking of earlier: Use a simple numeric ID that you mod by the number > of records you want, automatically overwriting the oldest record when a > new one comes along.. I may have to put together a smallish trigger to > keep the IDs in range, perhaps a manual implementation of a simple > sequence to pull a value from, then use that as the record ID.
That works but what do you sort by to get the entries in order?
