archiving using CTE (pg)

archive.sql

WITH archive AS ( 
	DELETE FROM arrivals 
	WHERE created_at < now() - interval '1 hours'
	RETURNING *
)
INSERT INTO archived_arrivals 
SELECT * FROM archive;

DELETE FROM archived_arrivals 
WHERE created_at < now() - interval '3 days';