Subject Re: [firebird-support] Historic tables design
Author Aldo Caruso

your approach is correct provided the fact that in your case you
criteria to define a record as historic is only its timestamp ( be it
limited to the current day or any other date time criteria ).

Unfortunately that is not my case: records contain real estate data
and they become historic when properties are sold or the bid is
withdrawn, a manual criteria which is reflected by a boolean flag in a
field (or by moving the record into another table)

Aldo Caruso