Moonlight Embrace wrote:
Thanks. I can do that :). Is the history in another table, or is it just pulled from the old table?
History is pulled from the old table, so anything you remove will just... disappear. :)
If you want to record all revisions but just remove the _text_ to save space, you might do something like this:
UPDATE old SET old_text='(This revision has expired.)' WHERE old_timestamp < '20040401120000';
or such.
-- brion vibber (brion @ pobox.com)