Hi,
We need to design a system, that keeps past/present/future data based on a time axis.

ie. The system needs to know what price a product will be at times in future, was in time in past, and is currently.

see this link for further details.

http://www.databasejournal.com/features/db2/article.php/3914031/Lets-Do-the-Time-Warp-Temporal-Data-Comes-To-IBM-DB2.htm

I want to know if anyone has attempted to meet this type of requirement in firebird?

The simple way would be to add a TIMESTAMP to the primary key. I don't like this as it would make access of the data inordinately difficult and slow.

Kind Regards,

Robert