code:

insert into normal (select * from archive where post = :post_number)
delete from archive where post = :post_number