>Hi Nadya,
>
>Have you considered using a update trigger to do this?
I believe the Update trigger could not change its own table. Am I right? We thought about using Table's rule, but there are more than 100 tables needed to be changed and also we found, that if we set a rule, it updates all existing records in the table.
If it's not broken, fix it until it is.
My Blog