...

> Is it correct to use: "update test set f2 = new.f1;" ?

As I know , yes is correct.

>

New.xx and old.xx are "at the record update moment" values, so if you
issue the update command putting new.f2 has no sense within the update
trigger.

> Will "update test set new.f2 = new.f1;" work ?

Instead of this you may simply put a line
new.f2 = new.f1;
(of course you are WITHIN the code of before/after trigger)

> --
> Aage J.
>

Doru