Hi, > I have some tables (which can get pretty large) in which I want to > record 'current' data as well as 'historical' data.
Another solution can be using a trigger and function to record every transaction to a 'logging' table. This way you'll have one 'current' table and one 'historical' table The 'historical' table will contain every transaction recorded from the current table. Regards Rudi. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])